is it possible to create a rolling average in a pivot table?

dave_f

New Member
Joined
Jul 17, 2007
Messages
33
Hi All,

If I have a table of data like so:


Person Day Value
Joe 1/1/2010 100
Bob 1/1/2010 60
Jim 1/1/2010 75
Joe 1/2/2010 110
Bob 1/2/2010 61
Jim 1/2/2010 73
Joe 1/3/2010 130
Bob 1/3/2010 67
Jim 1/3/2010 95
...etc.

I'd like to create a pivot table that will give me a rolling weekly average by the dates, but still be able to filter on the person name. So in the pivot table for date 1/7/2010 it should show the average of 1/1/2010 - 1/7/2010.

Can anyone tell me if this is possible, and if so, how? My actual example has many more fields than this so creating the rolling averages inside the data table would be a pain and I'd like to avoid it if possible.


thanks in advance for any help you can provide.

Dave
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Forum statistics

Threads
1,148,144
Messages
5,745,044
Members
423,917
Latest member
Frank1931

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top