•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Pivot Table Behavior - Renamed Subtotal on Accident
Our take
Have you accidentally renamed your Pivot Table's subtotal field and can’t seem to restore it? This common frustration can disrupt your data analysis, but there’s hope. Understanding the nuances of Pivot Table behavior is key to regaining control without starting from scratch. In this article, we'll explore practical solutions to reset your subtotal field and optimize your Pivot Table for seamless functionality. Stay with us to discover the fixes that can save you time and enhance your workflow!
I'm having an issue where at some point I overwrote the subtotal field from being the default 'Row field + " - Total"' and I can't get it back to normal.
I've tried adding/removing the row, refreshing, changing field settings to custom and back to automatic, changing to compact and then tabular, etc.
The row it belongs to isn't custom named either
Any ideas short of rebuilding the entire pivot table?
[link] [comments]
Read on the original site
Open the publisher's page for the full experience