This content has been marked as final.
Show 6 replies

Re: Calculating Monthly Variance in Pivot
Sunny Talwar Jan 26, 2017 9:28 AM (in response to John Hillock)May be like this:
CostExpression  Avg(TOTAL Aggr(CostExpression, Month))
Where Replace CostExpression with your expression for Cost

Re: Calculating Monthly Variance in Pivot
Sunny Talwar Jan 26, 2017 9:29 AM (in response to Sunny Talwar )Assuming is it Sum(Cost)
Sum(Cost)  Avg(TOTAL Aggr(Sum(Cost), Month))

Re: Calculating Monthly Variance in Pivot
John Hillock Jan 26, 2017 9:32 AM (in response to Sunny Talwar )Thank you! That worked. What if I wanted to run it as a rolling nperiod average?

Re: Calculating Monthly Variance in Pivot
Sunny Talwar Jan 26, 2017 9:33 AM (in response to John Hillock)Can you elaborate with an example?

Re: Calculating Monthly Variance in Pivot
John Hillock Jan 26, 2017 9:35 AM (in response to Sunny Talwar )Yes, so in the same table above, if I wanted the December number to the a threeperiod average, it would calculate the average of December, November, and October. If I wanted the same calculation for August, it would calculate the average for August, July, and June.

Re: Calculating Monthly Variance in Pivot
Sunny Talwar Jan 26, 2017 9:37 AM (in response to John Hillock)May be like this
CostExpression  RangeAvg(Above(CostExpression, 0, 3))



