Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a pivot table with 2 dimensions and 1 expression. Here in the expression i want to show the % contribution of the second dimension. I tried using partial sums on second dimension, but couldn't put that in the denominator of the expression to show its contribution. Is there any way we can implement this?
Regards,
Diwakar
Hi,
use Total in your expression
for calculating %
Your Expression Like
yourExpression/Sum(Total<2nd DimensionName>Sales)
Regards
Hi,
use Total in your expression
for calculating %
Your Expression Like
yourExpression/Sum(Total<2nd DimensionName>Sales)
Regards
Works perfectly. Thanks..