PivotGridFieldBase.GrandTotalText Property

Gets or sets the text displayed within the Grand Total‘s header that corresponds to the current field.

Namespace: DevExpress.XtraPivotGrid

Assembly: DevExpress.PivotGrid.v23.2.Core.dll

NuGet Packages: DevExpress.PivotGrid.Core, DevExpress.Win.Navigation

Declaration

C#

[DefaultValue("")]
public string GrandTotalText { get; set; }

VB.NET

<DefaultValue("")>
Public Property GrandTotalText As String

Property Value

Type	Default	Description
String	String.Empty	A string that represents the text displayed within the Grand Total‘s header that corresponds to the current field.

Remarks

This property allows the default text displayed within the Grand Total‘s header that corresponds to the current field to be overridden. This text is displayed when the current field is displayed within the Data Area and only when either of the following conditions is met:

• there is no visible field in the Column Header Area. In this case, the XtraPivotGrid control displays a single column which contains grand total values. The GrandTotalText property allows you to customize the text within this column header.
• there is no visible field in the Row Header Area. In this case, the XtraPivotGrid control displays a single row which contains grand total values. The GrandTotalText property allows you to customize the text within this row header.

When the GrandTotalText property is set to an empty string the default text for the Grand Total’s header is constructed in the form: “FieldCaption Total”. Here “FieldCaption” is the actual text displayed within the Field Header, which can be customized via the PivotGridFieldBase.Caption property. The default “Total” substring can be localized. See the Localization document for more information.

To get the actual text which is displayed within the Grand Total’s header use the PivotGridFieldBase.GetGrandTotalText method.

In the following images a data field’s GrandTotalText property is set to the default and custom values respectively:

GrandTotalText Value	Image
The GrandTotalText property of the “Total Sum” data field is set to an empty string.
The GrandTotalText property of the “Total Sum” data field is set to “Total Sum”.