Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
can you please elaborate ? what do you want to see and what is wrong ?
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.