Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Workspace segment percentage always 100%

Avatar

Level 6

WorkspacePcnt.png

Hi there!

I use many segments, but Totals do not show a % (in top row) or always 100% (lower row). In this example I would like to see how much makes 42k out of 545k.

Is there a workaround?

Thank you for your help.

Regards

Stefanie

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

It looks you want to see the percentage as a percentage of either the parent total or grand total, not the comparable segments.

As such I would suggest it as an enhancement.

View solution in original post

5 Replies

Avatar

Correct answer by
Community Advisor

It looks you want to see the percentage as a percentage of either the parent total or grand total, not the comparable segments.

As such I would suggest it as an enhancement.

Avatar

Level 6

I've created the idea:

Workspace: see % share of a segment

forums.adobe.com/ideas/11497

Please help me by voting

Avatar

Community Advisor

Done!

Pretty sure the exact feature you want to replicate is "Show Value As - % of column total" in excel pivot table.

https://www.pryor.com/blog/how-to-show-percentage-of-total-in-an-excel-pivottable/

Dave

Avatar

Level 6

Currently, if I add several segments (without breakdown), Total will be a sum of all the numbers which is not useful for me because of segment overlap.

2segmentsTotal.png

I would have expected 117k instead of 199k. If the Segments Total was empty, then the percentages below could use the above line as a base. Currently, the percentages on the bottom right always show (in sum) 100% or 0% when there is no data...

Your suggestion ("Show Value As - % of column total") is good, however parent total, % of the above would also be sufficient, i.e. further breakdowns' % can refer to the above only, instead of Grand Total, and have a value/sum of up to 100%...

Avatar

Level 6

Hi all,

I found out that I need to switch settings on the left to "Calculate totals based on all rows for each metric" !!