To control how grand totals are displayed in a pivot table, use the following properties.
C#:PivotTableLayoutActions.cs |
Worksheet worksheet = workbook.Worksheets["Report1"];
workbook.Worksheets.ActiveWorksheet = worksheet;
PivotTable pivotTable = worksheet.PivotTables["PivotTable1"];
pivotTable.ColumnFields.Add(pivotTable.Fields["Region"]);
pivotTable.Layout.ShowRowGrandTotals = false;
|
VB:PivotTableLayoutActions.vb |
Dim worksheet As Worksheet = workbook.Worksheets("Report1")
workbook.Worksheets.ActiveWorksheet = worksheet
Dim pivotTable As PivotTable = worksheet.PivotTables("PivotTable1")
pivotTable.ColumnFields.Add(pivotTable.Fields("Region"))
pivotTable.Layout.ShowRowGrandTotals = False
|
The image below shows the resulting PivotTable report.
C#:PivotTableLayoutActions.cs |
Worksheet worksheet = workbook.Worksheets["Report1"];
workbook.Worksheets.ActiveWorksheet = worksheet;
PivotTable pivotTable = worksheet.PivotTables["PivotTable1"];
pivotTable.ColumnFields.Add(pivotTable.Fields["Region"]);
pivotTable.Layout.ShowColumnGrandTotals = false;
|
VB:PivotTableLayoutActions.vb |
Dim worksheet As Worksheet = workbook.Worksheets("Report1")
workbook.Worksheets.ActiveWorksheet = worksheet
Dim pivotTable As PivotTable = worksheet.PivotTables("PivotTable1")
pivotTable.ColumnFields.Add(pivotTable.Fields("Region"))
pivotTable.Layout.ShowColumnGrandTotals = False
|
The image below shows the resulting PivotTable report.