Totals (Subtotals)
- 2 minutes to read
Subtotals (also called Totals) can be calculated for each grouping item (a grouping column or grouping row) to represent the aggregate value for each data field within the category. Subtotals are linked with the corresponding grouping item and are treated as grouping values.
Row Subtotals (or Row Totals) are rows which display subtotals calculated for outer row fields. Column Subtotals (or Column Totals) are columns which display subtotals calculated for outer column fields.
The ExpressPivotGrid control 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.
A column (or row) total consists of the Header and Total Values regions:
The table below lists the main properties which affect the appearance of subtotals.
Visibility | A field’s Totals For column totals, the pivot grid’s Options For row totals, the pivot grid’s Options |
Cell Visibility | A field’s Data |
Custom Totals Availability | A field’s Totals |
Custom Total Collection | A field’s Custom |
Position | The pivot grid’s Options |
Header:
Contents | A field’s On |
Appearance | For totals and grand totals, the pivot grid’s Styles. For column totals, the pivot grid’s Styles. For row totals, the pivot grid’s Styles. To dynamically customize these style settings, handle the pivot grid’s Styles. Note These style settings do not modify an element’s background if the pivot grid is painted using the Windows XP (native) or Office2003 style. |
Custom Draw Event | For column totals, the pivot grid’s On For row totals, the pivot grid’s On |
Context Menu | Refer to the Grouping Value Context Menu topic. |
Hints | The pivot grid’s Options The pivot grid’s On |
Hit | The Hit |
#Total Values:
Contents | A field’s On |
Appearance | The pivot grid’s Styles. To dynamically customize these style settings, handle the pivot grid’s Styles. |
Custom Draw Event | The pivot grid’s On |
Hints | The pivot grid’s Options The pivot grid’s On |
Hit | The Hit |