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

Totals

Row Totals are rows which display sub-totals calculated for outer row fields. Column Totals are columns which display sub-totals calculated for outer column fields.

The Pivot Grid control supports automatic and custom totals. Automatic totals are calculated using a summary function which is specified by a corresponding data field. Custom totals can be calculated using any summary function. It’s possible to calculate multiple custom totals against a data field.

pivotgrid_totals

The following table lists the main properties affecting the element’s appearance.

Visibility

PivotGridControl.ShowColumnTotals

PivotGridControl.ShowRowTotals

PivotGridControl.ShowTotalsForSingleValues

PivotGridControl.ShowCustomTotalsForSingleValues

PivotGridField.ShowTotals

PivotGridField.TotalsVisibility

Location

PivotGridControl.ColumnTotalsLocation

PivotGridControl.RowTotalsLocation

Custom Totals Visibility

PivotGridField.TotalsVisibility

Custom Totals Collection

PivotGridField.CustomTotals

Format

PivotGridField.TotalValueFormat