In this case, you’ll need a second subtotal row. How to add a second subtotal row to a PivotTable in Excel The default PivotTable is useful, but you might need more information.

Doing so will move the subtotal rows to the bottom of their groups. As you can see in Figure E, it also displays the new grand total row based on the GrandTotal column at the bottom of the PivotTable.

How to create a calculated column in an Excel table The Total row we discussed earlier calculates table data in a column, but you can also calculate data across rows.