Grand Totals

Dec 17, 2020

Row Grand Total is a row that displays summary totals calculated against all rows. Column Grand Total is a column that displays 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 (via PivotGridSettings.OptionsView .ShowColumnGrandTotals )

PivotGridOptionsViewBase.ShowRowGrandTotals (via PivotGridSettings.OptionsView .ShowRowGrandTotals )

PivotGridOptionsViewBase.ShowGrandTotalsForSingleValues (via PivotGridSettings.OptionsView .ShowGrandTotalsForSingleValues )

Header:

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

Grand Total Values:

Characteristics

Members

| | --- | --- | |

Appearance

PivotGridStyles.GrandTotalCellStyle (via PivotGridSettings.Styles .GrandTotalCellStyle )

| |

Contents

PivotGridFieldBase.GrandTotalCellFormat (via MVCxPivotGridField .GrandTotalCellFormat )

The PivotGridSettings.CustomCellDisplayText event.