•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
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#rows.com
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#intelligent data visualization
#Pivot Table
#average
#Grand Total
#unpivoted
#Overview sheet
#values
#data
#remove
#screenshot
#field
#row