Totals

  • 2 minutes to read

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.

pivotgrid_totals

Custom totals can be calculated using any summary function. It's possible to calculate multiple custom totals against a data field.

PivotGrid-CustomTotals

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

PivotGridField.CustomTotals

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 (see the PivotGridControl.LookAndFeel property).

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