Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table (Running averages)
Using a pivot table I need to create a running average of values for the last
10 days. It's easy to display the averages for each day and filter off everything but the last 10 days BUT... I can't get a running average working. The goal is to develop a dynamic graph/chart that shows the average with a trend line for the running average to see if things are improving. There is a built in function for running totals but I need the average of the previous numbers not the totals. I am somewhat familiar with calculated fields but am not smart enough to pull it all together to make this work. Any help would be appreciated. Dan |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using a Pivot Table Calculated Field to get a Unique Count | Excel Worksheet Functions | |||
Difference between Averages in a Pivot Table | Excel Worksheet Functions | |||
pivot table | Excel Worksheet Functions | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |