Division/Multiplication between 2 rows of same dimension.....

[#1]

Hi i have a pivot table like this , with one dimension and 6 expression.

i want to show the data for 28th august as numbers, but the other 2 days need to be expressed as percentages with respect to 28th august.

ie for Expression one the values should be  49, 48/49, 60/49

Is there any way to achieve this??

[christophebrault · Accepted solution]

Hi,

try this :

if(ColumnNo()=1, sum(Value),

sum(Value)/Before(sum(Value),ColumnNo()-1,1))