how to show as a % of in a table with multiple dimensions

[#1]

Dear All

I want to show the volumes as a percentage of the total volumes.

this works fine with below formula, where the dimension unit is ignored.

Sum(Volume)/ Sum({$< Unit= >}TOTAL Volume)))

but when I add the dimension Month on top it does not work anymore, as I want a 100% total for each month.

see attachment of what I am trying to achieve.

please to hear from you.

[#2]

try this

Sum(Volume)/ Sum({$< Unit= >}TOTAL Volume)

or this one

Sum(Volume)/ Sum(TOTAL Volume)

and then in chart properties-->number tab-->check on  show in percentage

[er_mohit]

Sum(Volume)/ Aggr(Sum(TOTAL Volume),Unit) or this one

Sum(Volume)/ Sum(TOTAL{$< Unit= >} Volume)))

[#4 · Accepted solution]

hi,

I did in sample qvw. please go through it...

Niranjan M.

[#5]

your option works , but not when I have the months on Top.

I replaced Unit with Month and that worked for me. thanks

[#6]

your option works , but not when I have the months on Top.

I replaced Unit with Month and that worked for me. thanks