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.

And that’s it. It took all of 20 seconds to create and format a table in Excel. How to use a Total row for quick calculations Next, you’ll add calculations to your table. This lets you ...