Grand Totals

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.

 

veGrandTotal_1

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

veGrandTotal_2

 

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.

See Also