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