Jun 21 2018 11:37 PM
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.
Jun 22 2018 06:51 AM
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.
Sep 27 2021 03:24 PM
Sep 27 2021 03:42 PM
Right click on the field and enable or disable subtotal
The question was about subtotals, not about grand totals.