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