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.
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 | Pivot Pivot Pivot Pivot Pivot |
Custom Totals Availability | |
Custom Total Collection |
Header:
Characteristics | Members |
---|---|
Appearance | |
Contents | The Pivot The ASPx |
Total Values:
Characteristics | Members |
---|---|
Appearance | Pivot |
Contents | The Pivot The ASPx |