TcxPivotGridField.CustomTotals Property

Provides indexed access to custom totals that are calculated for the current field.

Declaration

property CustomTotals: TcxPivotGridCustomTotalCollection read; write;

Property Value

Type
TcxPivotGridCustomTotalCollection

Remarks

To calculate custom totals, set the field’s TotalsVisibility property to tvCustom. Custom totals are calculated and displayed for column fields and row fields. The CustomTotals property provides access to a zero-based indexed collection of custom totals calculated for the current field. An item of this collection allows specifying the type of the summary function used to calculate the corresponding custom total and the format string used to display its value via the SummaryType and DisplayFormat properties, respectively.

You can use standard methods (such as Add, Delete, Insert and Clear) to manipulate the collection’s items. To determine the total number of custom totals within the collection, use the Count property.

At design time, the collection can be modified using a standard editor dialog which can be invoked by clicking the ellipsis button in the Object Inspector.

Refer to the Totals and Grand Totals topic for details on how totals are calculated and displayed in the ExpressPivotGrid.