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

Fri, 30 Aug 2013 10:48:29 GMT

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??

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

christophebrault — Fri, 30 Aug 2013 10:56:49 GMT

Hi,

try this :

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

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