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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

Workspace segment percentage always 100%

stefanies325986
Level 6
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
David-123
Correct answer by
Level 7
Level 7

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
David-123
Correct answer by
Level 7
Level 7

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

stefanies325986
Level 6
Level 6

I've created the idea:

Workspace: see % share of a segment

forums.adobe.com/ideas/11497

Please help me by voting

David-123
Level 7
Level 7

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

stefanies325986
Level 6
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%...

stefanies325986
Level 6
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" !!