3 Month Moving Average Dashboard

Hi ALL,

I'm trying to create a dashboard based on historical data to analyze using charts and trendlines. I'm using Excel 2007. The new Excel 2010 has functionality of using sparklines which make life more easier but we don't have it. Hence trying to use charts & trendlines instead.

Attachment is the sample file with data in tab "Data". I was able to create few report in "Report 1" & "Report 2" tabs and want to be able to create similar to "Sample Report" tab. The report shows current month average, previous month average and 3 month moving average data by region and countries for type of updates we make. But I'm strugling with 3 month moving average. Can we do this report in Pivot table format as well.

Any help is highly apprciated.

Excel Lover,
Duke