windowsforms-1691-controls-and-libraries-pivot-grid-ui-elements-totals.md
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.
PivotGridControl 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 table below lists the main properties which affect an element’s appearance:
|
Visibility
|
PivotGridOptionsViewBase.ShowColumnTotals
PivotGridOptionsViewBase.ShowRowTotals
PivotGridOptionsViewBase.ShowTotalsForSingleValues
PivotGridOptionsViewBase.ShowCustomTotalsForSingleValues
PivotGridFieldOptions.ShowTotals
PivotGridFieldBase.TotalsVisibility
| |
Custom Totals Availability
|
PivotGridFieldBase.TotalsVisibility
| |
Custom Total Collection
|
| |
Total Location
|
PivotGridOptionsViewBase.RowTotalsLocation
PivotGridOptionsViewBase.ColumnTotalsLocation
|
Header:
|
Appearance
|
The PivotGridAppearancesBase.FieldValueTotal property.
Note : the appearance settings are not in effect if the control is painted using the Windows XP, Office2003 or Skin painting scheme.
| |
Custom Draw Event
|
The PivotGridControl.CustomDrawFieldValue event.
| |
Contents
|
The PivotGridFieldBase.TotalValueFormat and PivotGridCustomTotalBase.Format properties provide settings used to format the text within the total headers.
The PivotGridControl.FieldValueDisplayText event enables the display text of individual values to be customized.
|
Total Values:
|
Appearance
|
The PivotGridAppearancesBase.TotalCell, PivotGridAppearancesBase.CustomTotalCell, PivotGridCustomTotal.Appearance and PivotGridFieldAppearances.CellTotal properties.
| |
Custom Draw Event
|
The PivotGridControl.CustomDrawCell event.
| |
Contents
|
The PivotGridFieldBase.TotalCellFormat and PivotGridCustomTotalBase.CellFormat properties provide settings used to format the values.
The PivotGridControl.CustomCellDisplayText event enables the display text of individual values to be customized.
|
See Also