How to: Display or Hide Grand Totals for a Pivot Table

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 

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 columns. 
pivotTable.Layout.ShowColumnGrandTotals = False 

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;