Grand Totals
- 2 minutes to read
Row Grand Total(s) are row(s) which display summary totals calculated against all the rows. Column Grand Total(s) are column(s) which display summary totals calculated against all the columns.
The column (or row) grand total consists of the Header and Grand Total Values regions:
The table below lists the main properties of the pivot grid which affect the appearance of grand totals.
Visibility | The Options For column grand totals, the Options For row grand totals, the Options |
Cell Visibility | A field’s Data |
Position | The Options |
Header:
Contents | For column grand totals, the Options For row grand totals, the Options |
Appearance | For totals and grand totals, the Styles. For column grand totals, the Styles. For row grand totals, the Styles. To dynamically customize these style settings, handle the 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 grand totals, the On For row grand totals, the On |
Hints | The Options The pivot grid’s On |
Hit | The Hit |
Grand Total Values:
Contents | The On |
Appearance | The Styles. To dynamically customize these style settings, handle the Styles. |
Custom Draw Event | The On |
Hints | The Options The pivot grid’s On |
Hit | The Hit |