Pivot Table - How to compare values for current month to average of previous 6 months

Hello. I have daily revenue values in an Access database and I have a pivot table in Excel that is connected to that Access database. I need a way to compare the current day of the current month to the average of the same day in the previous 6 months. Is there a way to do this automatically in a pivot table? Or any other method?

Here is an example of what I mean. I need a way to caculate the current day to avg same day previous 6 months as automatically as possible.

Thanks in advance for any help you can provide!

November 2nd, 2011 6:39pm

Excel 2010 PivotTable
Find daily difference from 6 month average.
Results outside PT.
No outside reference (i.e. Access)
http://c3017412.r12.cf0.rackcdn.com/11_04_11.xlsx

If you get *.zip, don't unzip, just rename *.xlsx

Free Windows Admin Tool Kit Click here and download it now
November 4th, 2011 5:05pm
Do you know how we can implement the same problem as above in DAX?
June 10th, 2015 12:27pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics