The requested page is not available for the requested platform. You are viewing the content for Default platform.

Grand Totals

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.

 

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 (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.

See Also