Grand Totals
Row Grand Total(s) are row(s) that display summary totals calculated against all the rows. Column Grand Total(s) are column(s) that display summary totals calculated against all the columns.
The table below lists the main properties that affect the element’s appearance:
Visibility | PivotGridOptionsViewBase.ShowColumnGrandTotals PivotGridOptionsViewBase.ShowRowGrandTotals |
Header:
Appearance | The PivotGridAppearancesBase.FieldValueGrandTotal property. Note: appearance settings are not in effect if the control is painted using Windows XP, Office2003 or a Skin painting scheme. |
Custom Draw Event | The PivotGridControl.CustomDrawFieldValue event. |
Contents | The default value (‘Grand Total’) can be changed by creating a Localizer object or by handling the PivotGridControl.FieldValueDisplayText event. |
Grand Total Values:
Appearance | The PivotGridAppearancesBase.GrandTotalCell and PivotGridFieldAppearances.CellGrandTotal properties. |
Custom Draw Event | The PivotGridControl.CustomDrawCell event. |
Contents | The PivotGridFieldBase.GrandTotalCellFormat property. The PivotGridControl.CustomCellDisplayText event. |