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 Field Settings dialogue box there will be a Subtotals and Filters tab. I am using Excel 2016, and I see no Subtotals and Filters tab. The two tabs I see are "Summarize Values By" and "Show Values As". I see nowhere to remove the subtotals. What am I missing here??!
I have attached a screen shot of what I see when I open the Value Field Settings dialogue.
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?Right click on the field and enable or disable subtotal
The question was about subtotals, not about grand totals.
