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
Custom Totals Visibility	PivotGridField.TotalsVisibility
Custom Totals Collection	PivotGridField.CustomTotals
Format	PivotGridField.TotalValueFormat