TcxPivotGridCrossCell.SummaryCells Property

Provides indexed access to the summary values calculated for a particular field.

Declaration

property SummaryCells[AIndex: Integer]: TcxPivotGridCrossCellSummary read; default;

Property Value

Type
TcxPivotGridCrossCellSummary

Remarks

Summary values are calculated for all the data fields (including the invisible data fields) and the fields whose values are used to determine the sort order for the “sorted by summary“ fields. All these fields are stored in the pivot grid’s SummaryFields property. The summary values for these fields can be accessed via the SummaryCells zero-based indexed collection. To access summary values for a particular field, pass the value of the field’s SummaryIndex property as an index to the cross cell’s SummaryCells collection. Alternatively, you can use the GetSummaryByField function.

Use the OptionsData.CalculationBase property to specify how summary values are calculated.