Rolling/Moving Average

SammyG83

New Member
Joined
Jan 19, 2011
Messages
6
Hello

Is there anyway to automatically calculate a 12 month rolling average from a pivot table, without having to create an additional seperate table?

I've tried many searches about this on the internet and came up with nothing that seems to be conclusive :confused:

Any help you could offer me would be greatly appreciated...


Sam.x
 

Some videos you may like

Excel Facts

Shade all formula cells
To shade all formula cells: Home, Find & Select, Formulas to select all formulas. Then apply a light fill color.

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,670
Office Version
2013
Platform
Windows
Hi,
as far as I know this would have to be done in a separate table or in a row/column outside of the pivot table, unless you can interpose some form of advanced SQL programming between the source data and the pivot table record source (offhand I've no idea how I'd start that).

It's not bad to use more than one stage to successively roll up the data to a final report - such as raw data -> intermediate or summarized data to bang reports off of -> final report tables. You can use a pivot table (or not) at any given stage. I like my raw data and/or intermediate tables to be solid data grids of continuous data. This makes it easier to work with and keeps the presentation of the information separate from the maintenance and analysis of the data.

ξ
 

Watch MrExcel Video

Forum statistics

Threads
1,102,291
Messages
5,485,973
Members
407,523
Latest member
Talicius

This Week's Hot Topics

Top