GrandTotalName Property Example
This example sets the grand total heading label to "Regional Total" in the second PivotTable report on the active worksheet.
ActiveSheet.PivotTables("PivotTable2").GrandTotalName = "Regional Total"