Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

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.

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