This content has been marked as final.
Show 5 replies

Relative percentage in a pivot table
Sunil Chauhan Apr 23, 2012 9:42 AM (in response to Abhinav Agarwal)calculate Y1 value in first expression
calculate Y2 value in second expression
calculate Y3 value in third expression
then in forth expression
column(2)/column(1)
in fifth
column(3)/column(2)
hope this helps

Relative percentage in a pivot table
Celambarasan Adhimulam Apr 23, 2012 9:44 AM (in response to Abhinav Agarwal)Hi,
Check with this
Sum(Sales)/Above(Sum(Sales))
Celambarasan

Relative percentage in a pivot table
Abhinav Agarwal Apr 23, 2012 9:59 AM (in response to Celambarasan Adhimulam )Hello Celambarasan Adhimulam
Indeed this is what I tried, but adding this calculation Sum(Sales)/Above(Sum(Sales)) to the expression ads a column after the sales column and not as a row below years. And so it is not calculating correctly the ABOVE().


Re: Relative percentage in a pivot table
langaar9 Apr 23, 2012 4:00 PM (in response to Abhinav Agarwal)If you are trying a multidimensional table, the expression should be: sum(Sales)/above(total sum(Sales)). Then it appears to work as you desire.

test1.qvw 160.8 K


Re: Relative percentage in a pivot table
Abhinav Agarwal Apr 24, 2012 4:11 AM (in response to Abhinav Agarwal)I think it was the Total, it works fine!
Thanks a lot!
Cheers!