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.

The end total (Grand Total) is the same as it was in the original table. Now let’s really mix things up by dragging Region to the Rows field. Doing so displays even more details about the source ...