Expand Minimize

PivotTable.RowGrand Property (Excel)

True if the PivotTable report shows grand totals for rows. Read/write Boolean.

expression .RowGrand

expression A variable that represents a PivotTable object.

This example sets the PivotTable report to show grand totals for rows.

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable 
pvtTable.RowGrand = True
Show:
© 2015 Microsoft