•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
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]
Want to read more?
Check out the full article on the original site
Tagged with
#row zero
#rows.com
#Excel compatibility
#Excel alternatives for data analysis
#Pivot Table
#Subtotal
#Row field
#Field settings
#Refresh
#Adding/removing row
#Compact
#Tabular
#Custom
#Automatic
#Rebuilding
#Normal
#Default
#Naming
#Behavior
#Issue