ColumnGrand Property

Applies To

PivotTable object.

Description

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

See Also

RowGrand property.

Example

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

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
pvtTable.ColumnGrand = True