I've searched through the archives and have come up empty.
I want to know if it is possible to calculate a moving average in a pivot table.
My data is formatted as:
Column headings:
Date / Part number / Shipped on time
Data fields:
5/10/11 / (text field) / 1 or 0 (1 = on time, 0 = late)
On a monthly basis i prepare several reports for delivery performance using simple pivot tables and its pretty straightforward.
I want to look at tracking a 3 month moving average of the Shipped on time column. The number of entries will be different month to month.
example:
January we ship 30 lines
February we ship 15 lines
March we ship 45 lines
For the 3 month moving average for March I want to include all of the lines for January - March.
I can do this manually but I'm hoping someone has a clever way to add some calculated fields to the pivot table to get what I'm after.
Thanks in advance!
Jim
I want to know if it is possible to calculate a moving average in a pivot table.
My data is formatted as:
Column headings:
Date / Part number / Shipped on time
Data fields:
5/10/11 / (text field) / 1 or 0 (1 = on time, 0 = late)
On a monthly basis i prepare several reports for delivery performance using simple pivot tables and its pretty straightforward.
I want to look at tracking a 3 month moving average of the Shipped on time column. The number of entries will be different month to month.
example:
January we ship 30 lines
February we ship 15 lines
March we ship 45 lines
For the 3 month moving average for March I want to include all of the lines for January - March.
I can do this manually but I'm hoping someone has a clever way to add some calculated fields to the pivot table to get what I'm after.
Thanks in advance!
Jim
