Skip to main content

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, PivotGridField.ShowTotals, PivotGridField.TotalsVisibility

Custom Totals Visibility

PivotGridField.TotalsVisibility

Custom Totals Collection

PivotGridField.CustomTotals

Format

PivotGridField.TotalValueFormat