Syntax

expression.ColumnGrand

expression A variable that represents a PivotTable object.

Example

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

Visual Basic for Applications 
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable pvtTable.ColumnGrand = True
column grand Column Grand Property ColumnGrand ColumnGrand Property Set the pivot table to shown grand totals? Toggle column grand totals?

See also: