Totals
Row Totals are rows that display sub-totals calculated for outer row fields. Column Totals are columns that display sub-totals calculated for outer column fields.
Pivot Grid supports automatic and custom totals. Automatic totals are calculated using a summary function specified by a corresponding data field. Custom totals can be calculated using any summary function. It is possible to calculate multiple custom totals against a data field.
A column (or row) total consists of the Header and Total Values regions.
The table below lists the main properties that affect element appearance.
Characteristics | Members |
|---|---|
Visibility | PivotGridOptionsViewBase.ShowColumnTotals (via PivotGridSettings.OptionsView.ShowColumnTotals) PivotGridOptionsViewBase.ShowRowTotals (via PivotGridSettings.OptionsView.ShowRowTotals) PivotGridOptionsViewBase.ShowTotalsForSingleValues (via PivotGridSettings.OptionsView.ShowTotalsForSingleValues) PivotGridFieldBase.TotalsVisibility (via MVCxPivotGridField.TotalsVisibility) |
Custom Totals Availability | PivotGridFieldBase.TotalsVisibility (via MVCxPivotGridField.TotalsVisibility) |
Custom Total Collection | PivotGridField.CustomTotals (via MVCxPivotGridField.CustomTotals) |
Header:
Characteristics | Members |
|---|---|
Appearance | PivotGridStyles.FieldValueTotalStyle (via PivotGridSettings.Styles.FieldValueTotalStyle) |
Contents | PivotGridFieldBase.TotalValueFormat (via MVCxPivotGridField.TotalValueFormat) PivotGridCustomTotalBase.Format (PivotGridCustomTotalBase descendants are stored in the MVCxPivotGridField.CustomTotals collections) The PivotGridSettings.FieldValueDisplayText event enables the display text of individual values to be customized. |
Total Values:
Characteristics | Members |
|---|---|
Appearance | PivotGridStyles.TotalCellStyle (via PivotGridSettings.Styles.TotalCellStyle) PivotGridStyles.CustomTotalCellStyle (via PivotGridSettings.Styles.CustomTotalCellStyle) |
Contents | PivotGridFieldBase.TotalCellFormat (via MVCxPivotGridField.TotalCellFormat) PivotGridCustomTotalBase.CellFormat (PivotGridCustomTotalBase descendants are stored in the MVCxPivotGridField.CustomTotals collections) The PivotGridSettings.CustomCellDisplayText event enables the display text of individual values to be customized. |