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

PivotField.SubtotalCaption Property

Gets or sets the text to be displayed in the field’s subtotal row or column heading.

Namespace: DevExpress.Spreadsheet

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

Declaration

string SubtotalCaption { get; set; }

Property Value

Type Description
String

A String value that specifies the custom subtotal label.

Remarks

Use the SubtotalCaption property to specify the text to be displayed in the subtotal row or subtotal column displayed for each item in the specified PivotField if this field is currently shown as an outer row or column field.

pivotTable.Fields["Category"].SubtotalCaption = "Total Sales";

The image below illustrates the result of code execution.

PivotTable_PivotField_CustomSubtotalCaption

Tip

The subtotal rows for items of an outer row field in compact or outline form are displayed only when the field’s PivotFieldLayout.SubtotalOnTop property is false, so that subtotals are shown below of each item in the field.

See Also