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.
Matt Mickle
The question is about 1 column, not all. How is this done if it is only for 1?
The question is about 1 column, not all. How is this done if it is only for 1?
Right click on the field and enable or disable subtotal
The question was about subtotals, not about grand totals.
This is it! Thank you!
