Script calculation, Charting rolling months, average calculation

[#1]

Hello,

I have a need to create a bar chart which will display the past 12 months including the current month with some calculations.

Rolling 12 months formula is available in plenty across the community, but my problem is calculating the average of a particular column from previous year. I have attached an excel which covers all the details, let me know if you need more information.

Thanks.

[sunny_talwar]

Is this a different question than what you have asked here: Rolling Sum/Rolling Average at Script

[#3]

Yes this is the actual question, and the other question is a part of it. Please give me your suggestions on this.

[#4]

Any suggestions?

[#5]

Is there a way to pick only the last value of every month? Fisc_Day_Of_Mth_Nbr is the month days column for me.