• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Running Average in Pivot Tables

A

Alexis

Member
Hi

Does anyone know if it is possible to calculate running averages in a pivot table?

I've attached a workbook where I've done it outside of the pivot table using an AVERAGEIF formula, however I would like to be able to do it within the pivot table if possible.

Thanks.
Alexis
 

Attachments

In short, no, you can't do it within the PivotTable. The best way would be to do it like you've posted. :(
 
You must log in or register to reply here.
Back
Top