Select PivotTable Tools Ribbon-> Design tab -> Subtotals (in Layout Group).



1. Drag at least two fields to the Row Labels.
2. Select a cell in the first Row Label field, right click and select Field Settings -> Subtotals & Filters tab.



Automatic: Excel uses the SUM formula as default when inserting subtotals.
Custom: Select this option to insert one or more functions.
None: Displays the PivotTable report without subtotals.