How to let a pivot caculate subtotals as 100%

[#1]

Hi Guys,

I have a pivot that has4 dimensions and 2 expessions, it looks like below screenshot. I would like to ask if it is possible to calculate the subtotals(marked in red) as 100%.

The problem probably is in my contribution expression which is:

Count (RMA#) / Count (total RMA#)

Any suggestion is more than welcome,

thanks

Michiel

[#2 · Accepted solution]

Hi,

Please check attached, if this is want u want......

[#3]

Hi,

You just made my day, Thank you many times! It is the exact answer to my question.

Michiel