Prevent subtotals in certain columns of a pivot table

Copper Contributor

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.

3 Replies

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?

@JenBo 

Right click on the field and enable or disable subtotal

image.png

The question was about subtotals, not about grand totals.