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

Workspace segment percentage always 100%

Avatar

Avatar
Validate 1
Level 6
stefanies325986
Level 6

Likes

140 likes

Total Posts

109 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 1
Level 6
stefanies325986
Level 6

Likes

140 likes

Total Posts

109 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
stefanies325986
Level 6

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
Validate 10
Level 5
David-123
Level 5

Likes

110 likes

Total Posts

130 posts

Correct Reply

17 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Give Back 5
Give Back 3
View profile

Avatar
Validate 10
Level 5
David-123
Level 5

Likes

110 likes

Total Posts

130 posts

Correct Reply

17 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Give Back 5
Give Back 3
View profile
David-123
Level 5

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
Validate 10
Level 5
David-123
Level 5

Likes

110 likes

Total Posts

130 posts

Correct Reply

17 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Give Back 5
Give Back 3
View profile

Avatar
Validate 10
Level 5
David-123
Level 5

Likes

110 likes

Total Posts

130 posts

Correct Reply

17 solutions
Top badges earned
Validate 10
Validate 1
Contributor
Give Back 5
Give Back 3
View profile
David-123
Level 5

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
Validate 1
Level 6
stefanies325986
Level 6

Likes

140 likes

Total Posts

109 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 1
Level 6
stefanies325986
Level 6

Likes

140 likes

Total Posts

109 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
stefanies325986
Level 6

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
Validate 1
Level 6
stefanies325986
Level 6

Likes

140 likes

Total Posts

109 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 1
Level 6
stefanies325986
Level 6

Likes

140 likes

Total Posts

109 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
stefanies325986
Level 6

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
Validate 1
Level 6
stefanies325986
Level 6

Likes

140 likes

Total Posts

109 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile

Avatar
Validate 1
Level 6
stefanies325986
Level 6

Likes

140 likes

Total Posts

109 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 50
Boost 5
Boost 3
Boost 25
View profile
stefanies325986
Level 6

03-09-2019

I've created the idea:

Workspace: see % share of a segment

forums.adobe.com/ideas/11497

Please help me by voting