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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,645
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,099,080
Messages
5,466,494
Members
406,484
Latest member
kaksolver

This Week's Hot Topics

Top