Inside the Tables group, click PivotTable ... The Grand Total row is now at the bottom of the PivotTable and displays Grand Total. Excel seems to know that this is a grand total and not a subtotal.

Displaying subtotals, grand totals, and otherwise summarizing data is a common report feature. You can display a running ... there’s an unforgiving catch: The table must have a column of unique ...