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.

The Pivot Grid control 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’s 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, which affect an element’s appearance:

Characteristics	Members
Visibility	PivotGridOptionsViewBase.ShowColumnTotals PivotGridOptionsViewBase.ShowRowTotals PivotGridOptionsViewBase.ShowTotalsForSingleValues PivotGridOptionsViewBase.ShowCustomTotalsForSingleValues PivotGridOptionsViewBase.RowTotalsLocation PivotGridOptionsViewBase.ColumnTotalsLocation PivotGridFieldBase.TotalsVisibility
Custom Totals Availability	PivotGridFieldBase.TotalsVisibility
Custom Total Collection	PivotGridField.CustomTotals

Header:

Characteristics	Members
Appearance	PivotGridStyles.FieldValueTotalStyle
Contents	The PivotGridFieldBase.TotalValueFormat and PivotGridCustomTotalBase.Format properties provide settings used to format the text within the total headers. The ASPxPivotGrid.FieldValueDisplayText event enables the display text of individual values to be customized.

Total Values:

Characteristics	Members
Appearance	PivotGridStyles.TotalCellStyle, PivotGridStyles.CustomTotalCellStyle
Contents	The PivotGridFieldBase.TotalCellFormat and PivotGridCustomTotalBase.CellFormat properties provide settings used to format values. The ASPxPivotGrid.CustomCellDisplayText event enables the display text of individual values to be customized.