Grand Totals

• Dec 17, 2020

Row Grand Total(s) are row(s) that display summary totals calculated against all rows. Column Grand Total(s) are column(s) that display summary totals calculated against all columns.

 

The column (or row) grand total consists of the Header and Grand Total Value regions:

 

The table below lists the main properties that affect element appearance:

Characteristics	Members
Visibility	PivotGridOptionsViewBase.ShowColumnGrandTotals PivotGridOptionsViewBase.ShowRowGrandTotals PivotGridOptionsViewBase.ShowGrandTotalsForSingleValues

Header:

Characteristics	Members
Appearance	PivotGridStyles.FieldValueGrandTotalStyle
Contents	The default value (‘Grand Total’) can be changed by handling the ASPxPivotGrid.FieldValueDisplayText event.

Grand Total Values:

Characteristics	Members
Appearance	PivotGridStyles.GrandTotalCellStyle
Contents	PivotGridFieldBase.GrandTotalCellFormat The ASPxPivotGrid.CustomCellDisplayText event.