Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community
I need to calculate a running Percentage accumulative in a pivot table.
My Syntax is as :
rangeSum(Before(sum(if(Year2Date(MonthYr,0,if(Month(vMaxMonth)>11,1,Month(vMaxMonth)+1),vMaxMonth),$(vMeasure)))/sum(TOTAL if(Year2Date(MonthYr,0,if(Month(vMaxMonth)>11,1,Month(vMaxMonth)+1),vMaxMonth),$(vMeasure))),0,ColumnNo()))
I am getting no output
Can you suggest a solution
Thanks
George