WinForms Controls > Controls and Libraries > Pivot Grid > UI Elements > Grand Totals

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, PivotGridOptionsViewBase.ShowGrandTotalsForSingleValues, PivotGridFieldOptions.ShowGrandTotal.

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 (see the PivotGridControl.LookAndFeel property).
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.

Grand Totals

See Also