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.

pivotgrid_totals

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.

See Also