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.