cumulative sum in pivot table showing wrong results.

[kishorj1982]

Hi all,

i have performed cumulative sume for three columns and added three columns for addition.

But after pivoting the table it is showing wrong results.

Please suggest.

thanks

[pradosh_thakur]

can you please elaborate ? what do you want to see and what is wrong ?

[sunny_talwar · Accepted solution]

Try this expression

if(Dimensionality()=0,$(vInvTurnsCalc)/$(vDivide),(((((rangesum(Before(RangeSum(sum(ThirdPartySales),sum(WODistribution),sum(SalesOrder))  ,0,ColumnNo(Total))))

/

If(Divide ='12', $(vBasePrice), $(vBasePrice)+Sum(InventoryValue_USD)))

/

$(vDivide))

/2)*-1))

Pivoted dimensions are unable to use Above or Below and RowNo() functions. In order to make them work, you can use Before or After and ColumnNo() function.