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