aspnet-3592-components-pivot-grid-ui-elements-totals.md
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.
A column (or row) total consists of the Header and Total Values regions:
The table below lists the main properties, which affect an element’s appearance:
|
Characteristics
|
Members
| | --- | --- | |
Visibility
|
PivotGridOptionsViewBase.ShowColumnTotals
PivotGridOptionsViewBase.ShowRowTotals
PivotGridOptionsViewBase.ShowTotalsForSingleValues
PivotGridOptionsViewBase.ShowCustomTotalsForSingleValues
PivotGridOptionsViewBase.RowTotalsLocation
PivotGridOptionsViewBase.ColumnTotalsLocation
PivotGridFieldBase.TotalsVisibility
| |
Custom Totals Availability
|
PivotGridFieldBase.TotalsVisibility
| |
Custom Total Collection
|
|
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