Rolling 6 Month RangeAvg in Pivot Table

[vidhya91gct]

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

Next

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

expecting Output:

Default_YearMonth	Jan2018	Feb2018	Mar2018	Apr2018	May2018	Jun2018	Jul2018	Aug2018	Sep2018	Oct2018
Average	9.4%	10.0%	10.0%	10.4%	10.5%	10.3%	7.6%	8.7%	9.8%	10.7%
Red	16	18	17	19	18	16	14	18	22	25
Total	171	169	169	165	166	175	184	184	183	189
Average Month	9.4%	10.7%	10.1%	11.5%	10.8%	9.1%	7.6%	9.8%	12.0%	13.2%

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

[sunny_talwar]

May be you need this

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