Forum Discussion
Prevent subtotals in certain columns of a pivot table
I am trying to prevent subtotaling in one of the columns of my pivot table. All the help pages I can find on this topic tell me to click on the field and then choose Field Settings, and that in that...
Hey Jonathan-
Hope you're doing well. Did you try doing the following?
1. Clicking in the Pivot Table Area
2. Navigating to the PivotTable Tools > Design Contextual Tab on the Ribbon
3. Go to SubTotals > Do not show SubTotals
If this doesn't work for your scenario could you please provide a bit more detail on your data structure / PivotTable structure please.