ColumnGrand Property [Excel 2003 VBA Language Reference]

  • Article

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

Example

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

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

Applies to | PivotTable Object

See Also | RowGrand Property