Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
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
Level 8

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
Level 8

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

Level 8

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