- 2 minutes to read
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:
Custom Totals Availability
Custom Total Collection
The ASPxPivotGrid.FieldValueDisplayText event enables the display text of individual values to be customized.
The ASPxPivotGrid.CustomCellDisplayText event enables the display text of individual values to be customized.