•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to remove the "average" from the top of the Pivot Table
Our take
Are you frustrated by the "Average" label at the top of your Pivot Table, especially after unpivoting your data? You're not alone—many users encounter this issue while trying to customize their reports. The good news is that you can retain the essential Grand Total values without the redundant "Average" heading. In this guide, we'll explore a straightforward method to effectively remove that term while keeping your data presentation intact. Dive in to discover how to enhance your Pivot Table for clearer insights!
Hi Everyone,
Since I've unpivoted the data, the Overview sheet is coming along much easier for me than I was having in my last thread.
Here is a screenshot of the Pivot Table
I know how to remove the "Grand Total" for the two averages at the end of the rom and colum but I want those. It's just the word average at the top of the Pivot Table. It always has the same name as the field in the "Values" box.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience