Totals

• Dec 17, 2020

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.

|

See Also

Data Field

Filter Field

Row Field

Grand Totals