Running Average in Pivot Table/Chart

Can anybody tell me if there is a way to construct/display a running average in a pivot table/chart.
I am trying to show the time it takes to close a ticket and would like to display the running average to show if the average closure time is going up or down.
Any help is appreciated.
greentatertot1970Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
dlmilleConnect With a Mentor Commented:
It doesn't appear Pivot Tables support MOVING AVERAGES, again, this can be something generated to the SIDE of the  Pivot Table.

http://chandoo.org/wp/2009/04/28/calculate-moving-average/  Provides an example if you read down the posts.


Dave
0
 
dlmilleCommented:
You need to create as Pivot Field (Calculated Field) to do that to avoid creating averages of averages.  I believe you want weighted average?

Here's a couple online tips.  If you load a non-confidential spreadsheet, I'll show you how to build it in, if further assistance is required:

http://www.mrexcel.com/forum/showthread.php?t=30526 

http://excel.tips.net/Pages/T002900_Weighted_Averages_in_a_PivotTable.html

Again, if you're going down a different path - upload a sample we can work it no problem.

Dave
0
 
dlmilleCommented:
I may have misread.  Let me work up an example which may be more in line to your query.

Dave
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
dlmilleCommented:
Yes - perhaps the solution is simpler than I initially thought.  I created a sample dataset with random start/end dates, then fixed those.  I then created a running average column which I pivoted and trended.

Is this going the direct you're looking for?

Dave sampleRunning-Average-Pivot-r1.xls
0
 
greentatertot1970Author Commented:
Yes... this looks like the direction I am wanting to take. I'll look at what you have provided. Thank you!
0
 
greentatertot1970Author Commented:
Thanks Dave!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.