Back to Devexpress

Grand Totals

windowsforms-1692-controls-and-libraries-pivot-grid-ui-elements-grand-totals.md

latest2.6 KB
Original Source

Grand Totals

  • Feb 25, 2021

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.

| |

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

Data Field

Totals