windowsforms-115412-controls-and-libraries-spreadsheet-examples-pivot-tables-how-to-display-or-hide-grand-totals-for-a-pivot-table.md
To control how grand totals are displayed in a pivot table, use the following properties.
| Property | Description |
|---|---|
| PivotLayout.ShowRowGrandTotals | Specifies whether to display a grand total column. |
| PivotLayout.ShowColumnGrandTotals | Specifies whether to display a grand total row. |
| PivotViewOptions.GrandTotalCaption | Specifies the text label for both the grand total column and grand total row. |
Worksheet worksheet = workbook.Worksheets["Report1"];
workbook.Worksheets.ActiveWorksheet = worksheet;
// Access the pivot table by its name in the collection.
PivotTable pivotTable = worksheet.PivotTables["PivotTable1"];
// Add the "Region" field to the column axis area.
pivotTable.ColumnFields.Add(pivotTable.Fields["Region"]);
// Hide grand totals for rows.
pivotTable.Layout.ShowRowGrandTotals = false;
Dim worksheet As Worksheet = workbook.Worksheets("Report1")
workbook.Worksheets.ActiveWorksheet = worksheet
' Access the pivot table by its name in the collection.
Dim pivotTable As PivotTable = worksheet.PivotTables("PivotTable1")
' Add the "Region" field to the column axis area.
pivotTable.ColumnFields.Add(pivotTable.Fields("Region"))
' Hide grand totals for rows.
pivotTable.Layout.ShowRowGrandTotals = False
The image below shows the resulting PivotTable report.
Worksheet worksheet = workbook.Worksheets["Report1"];
workbook.Worksheets.ActiveWorksheet = worksheet;
// Access the pivot table by its name in the collection.
PivotTable pivotTable = worksheet.PivotTables["PivotTable1"];
// Add the "Region" field to the column axis area.
pivotTable.ColumnFields.Add(pivotTable.Fields["Region"]);
// Hide grand totals for columns.
pivotTable.Layout.ShowColumnGrandTotals = false;
Dim worksheet As Worksheet = workbook.Worksheets("Report1")
workbook.Worksheets.ActiveWorksheet = worksheet
' Access the pivot table by its name in the collection.
Dim pivotTable As PivotTable = worksheet.PivotTables("PivotTable1")
' Add the "Region" field to the column axis area.
pivotTable.ColumnFields.Add(pivotTable.Fields("Region"))
' Hide grand totals for columns.
pivotTable.Layout.ShowColumnGrandTotals = False
The image below shows the resulting PivotTable report.