How to do percent of totals for different totals

art_in_sky

I have totals , value, dimension, three columns which i want to show as percent of totals vertical graph,
However, my totals is a different column and is distinct to each dimension . I want to display botton 10 rows for dimension that has the totals with the value in ( percent of total graph)
How do I achieve this.
I tried but the value bar is not reflected in the total bar. How do I get the graph to look like that?

ArborRose

Assuming data looks something like my sample below, you could create a percent of total and then rank those. With a rank you can decide whether to display them ascending or descending and how many by filtering or setting the limit rows value.

Dimension	Value	Totals
A	50	200
A	30	200
A	40	200
A	80	200
A	100	200
B	20	150
B	40	150
B	30	150
B	60	150
B	70	150
C	10	100
C	20	100
C	30	100
C	40	100
C	60	100

ArborRose

Assuming data looks something like my sample below, you could create a percent of total and then rank those. With a rank you can decide whether to display them ascending or descending and how many by filtering or setting the limit rows value.

Dimension	Value	Totals
A	50	200
A	30	200
A	40	200
A	80	200
A	100	200
B	20	150
B	40	150
B	30	150
B	60	150
B	70	150
C	10	100
C	20	100
C	30	100
C	40	100
C	60	100

art_in_sky

Thank you so much for your response. I applied the beast mode and am trying to the same in chart( there is a chart percent of the total vertical bar). I am trying to that with my data, however, my graph doesnt look the same as it is shown. I want to know how that percent of total graph vertical bar( under bar charts) is achieved.