•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
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]
Want to read more?
Check out the full article on the original site