Skip to main content

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

TcxPivotGridField.TotalsVisibility Property

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

#Declaration

Delphi
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.

See Also