Add and Remove Subtotals by using the Field Settings option on Pivot Table

  1. Right-click on a column heading that you wish to add or remove the subtotal view.

  1. Select Field Settings from the View and follow same procedures above to select Automatic for subtotals or None to remove subtotals