How to display multiple grand total rows in a Microsoft Excel ... a new subtotal at the bottom of the PivotTable but Excel knows that the amount calculations are grand totals and not subtotals.