Rolling 6 Month RangeAvg in Pivot Table

vidhya91gct — Fri, 12 Oct 2018 12:08:14 GMT

Hi All,

Please find the attached file.

I want to show the Average is calculating as below,

if(1 st column is getting same value as in the Average Month, else getting rangeAvg from Jan to Jun2018

Jul2018 is getting same value as in the Average Month, else getting RangeAvg from Jul to Dec2018 )

expecting Output:

I am using in the below expression and getting incorrect RangeAvg

=RangeAvg(Before(RangeSum(Average Month),0,6))

Please help me on it.

Thanks & Regards,

Vidhya K

Re: Rolling 6 Month RangeAvg in Pivot Table

sunny_talwar — Fri, 12 Oct 2018 12:17:13 GMT

May be you need this

=RangeAvg(Before(Sum(Average_Month), 0, 6))