Totals
- 2 minutes to read
Row Totals are rows which display sub-totals calculated for outer row fields. Column Totals are columns which display sub-totals calculated for outer column fields.
PivotGridControl supports automatic and custom totals. Automatic totals are calculated using a summary function which is 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.
The table below lists the main properties which affect an element’s appearance:
Visibility | Pivot Pivot Pivot Pivot |
Custom Totals Availability | |
Custom Total Collection | |
Total Location |
Header:
Appearance | The Pivot Note: the appearance settings are not in effect if the control is painted using the Windows XP, Office2003 or Skin painting scheme. |
Custom Draw Event | The Pivot |
Contents | The Pivot The Pivot |
Total Values:
Appearance | The Pivot |
Custom Draw Event | The Pivot |
Contents | The Pivot The Pivot |