Workspace segment percentage always 100%

Avatar

Avatar

stefanies325986

Avatar

stefanies325986

stefanies325986

30-08-2019

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

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

David-123

Avatar

David-123

David-123

30-08-2019

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.

Answers (4)

Answers (4)

Avatar

Avatar

David-123

Avatar

David-123

David-123

03-09-2019

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

Avatar

stefanies325986

Avatar

stefanies325986

stefanies325986

20-09-2019

Hi all,

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

Avatar

Avatar

stefanies325986

Avatar

stefanies325986

stefanies325986

04-09-2019

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

Avatar

stefanies325986

Avatar

stefanies325986

stefanies325986

03-09-2019

I've created the idea:

Workspace: see % share of a segment

forums.adobe.com/ideas/11497

Please help me by voting