Hi, Need help in caliculating average of last months from the current month, sample data is as below, pls help. Date New Return Rework New_app 01Mar2014 100 70 30 01Apr2014 125 80 40 01May2014 150 90 50 01Jun2014 175 100 60 average(01mar2014,01apr2014,01may2014)=125 {average of last 3 months) 01Jul2014 200 110 70 average(01apr2014,01may2014,01jun2014)=150 01Aug2014 225 120 80 average(01may2014,01jun2014,01jul2015)=175 01Sep2014 250 130 90 average(01jun2014,01jul2015,01aug2015)=200 Thanks in advance.
... View more