Totals

  • 1 min to read

Row Totals are rows that display sub-totals calculated for outer row fields. Column Totals are columns that 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 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.

 

veTotals

 

A column (or row) total consists of the Header and Total Values regions:

veTotals_2

 

The table below lists the main properties, which affect an element's appearance:

Characteristics

Members

Visibility

PivotGridOptionsViewBase.ShowColumnTotals

PivotGridOptionsViewBase.ShowRowTotals

PivotGridOptionsViewBase.ShowTotalsForSingleValues

PivotGridOptionsViewBase.ShowCustomTotalsForSingleValues

PivotGridFieldBase.TotalsVisibility

Custom Totals Availability

PivotGridFieldBase.TotalsVisibility

Custom Total Collection

PivotGridField.CustomTotals

Header:

Characteristics

Members

Appearance

PivotGridStyles.FieldValueTotalStyle

Contents

The PivotGridFieldBase.TotalValueFormat and PivotGridCustomTotalBase.Format properties provide settings used to format the text within the total headers.

The ASPxPivotGrid.FieldValueDisplayText event enables the display text of individual values to be customized.

Total Values:

Characteristics

Members

Appearance

PivotGridStyles.TotalCellStyle, PivotGridStyles.CustomTotalCellStyle

Contents

The PivotGridFieldBase.TotalCellFormat and PivotGridCustomTotalBase.CellFormat properties provide settings used to format values.

The ASPxPivotGrid.CustomCellDisplayText event enables the display text of individual values to be customized.

See Also