.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
Row

PivotViewOptions.GrandTotalCaption Property

Gets or sets the text to be displayed in grand totals for rows and columns in a pivot table.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v21.2.Core.dll

Declaration

string GrandTotalCaption { get; set; }

Property Value

Type Description
String

A String value that specifies the text label to be displayed in the grand total column and grand total row.

Property Paths

You can access this nested property as listed below:

Object Type Path to GrandTotalCaption
PivotTable
.View.GrandTotalCaption

Remarks

Use the GrandTotalCaption property to specify a custom label for grand totals in a PivotTable report. By default, the “Grand Total” string is used as the label for both the grand total column and grand total row.

To display or hide grand totals for rows and columns in a PivotTable report, use the PivotLayout.ShowRowGrandTotals and PivotLayout.ShowColumnGrandTotals properties.

pivotTable.View.GrandTotalCaption = "Total Sales";

The image below illustrates the result of code execution.

SpreadsheetPivotTable_GrandTotalCaption

See Also