Rolling/Moving Average

[SammyG83]

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

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


Sam.x

 

[xenou]

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.

ξ