Percentages in Stacked bar Chart

[#1]

i have an expression called Volume.

I wanted to show a satcked bar chart where - the total volume is 100%, and split by regions with percentages.

Thanks,

Thejo.

[rwunderlich]

Use Region as the second dimension. I assume you have a primary dimension like "Year".

Use sum(Volume) as the expression and check the "Relative" checkbox on the expression pane.

-Rob

[#3]

Yes, Primary dimension is month.

Secondary is region.

when i used the relative check box, it is not showing 100%, it shows as below. if select one month tehn it shows 100%.

[koushik_btech20]

Please see the .qvw file which is attached. I think it will help u....

[#5]

this is not yet working for me. my numbers are different. i have changed the numbers from your sheet,

[#6]

i missed the attachment in the earlier one.

[Gysbert_Wassenaar · Accepted solution]

See attached example.