TcxPivotGridField.TotalsVisibility Property

Specifies the type of the totals calculated and displayed within the pivot grid for the current field.

Declaration

property TotalsVisibility: TcxPivotGridTotalsVisibility read; write; default tvAutomatic;

Property Value

Type	Default
TcxPivotGridTotalsVisibility	tvAutomatic

Remarks

The ExpressPivotGrid allows you to calculate and display totals (also called subtotals) only for column fields and row fields. There are two types of totals that can be calculated for these fields: automatic totals and custom totals. Automatic totals are calculated using a summary function which is specified by the corresponding data field via the SummaryType property. Custom totals can be calculated using any summary function (see the field’s SummaryType property). You can calculate multiple custom totals for a data field.

All the possible values for the TotalsVisibility property are listed in the following table.

Value	Meaning
tvAutomatic	Automatic totals are calculated.
tvCustom	Custom totals are calculated. Use the field’s CustomTotals collection to specify custom totals and the summary functions that will be used to calculate them.
tvNone	Totals are not calculated for the current field.

The default value of the TotalsVisibility property is tvAutomatic.