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

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

xenou

MrExcel MVP, Moderator
Joined
Mar 2, 2007
Messages
16,669
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,101,925
Messages
5,483,735
Members
407,406
Latest member
ishipra

This Week's Hot Topics

  • Finding issue in If elseif else with For each Loop
    Finding issue in If elseif else with For each Loop I have tried this below code but i'm getting in Y column filled with W005. Colud you please...
  • MsgBox Error
    Hi Guys, I have the below error show up when i try and run my macro in File1 but works fine if i copy and paste the same code into file2. [ATTACH...
  • CELL FORMAT - IF CONDITION
    My Cell Format is [B]""0.00" Cr". [/B]But in the cell, it is showing 123.00 for editing. (123 is entry figure). (Data imported from other...
  • Show numbers nearly the same
    Is this possible. I have a number that can change very time eg 0.00001234 Then I have a lot of numbers 0.0000001, 0.0000002, 0.00000004...
  • Please i need your help to create formula
    I need a formula in cell B8 to do this >>if b1=1 then multiply ( cell b8) by 10% ,if b1=2 multiply by 20%,if=3 multiply by 30%. Thank you in...
  • Got error while adding column and filter
    Got error while adding column and filter In column Z has some like "Success" and "Error". I want to add column in AA if the Z cell value is...
Top