Totals

Apr 01, 2021

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.

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