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