# How to do percent of totals for different totals

Member

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?

Tagged:

• Coach

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

** Did this solve your problem? Accept it as a solution! **

• Coach

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