Syntax

expression.RowGrand

expression A variable that represents a PivotTable object.

Example

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

Visual Basic for Applications 
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable pvtTable.RowGrand = True
row grand Row Grand Property RowGrand rowgrand property show grand total rows in pivottable

See also: