TcxPivotGridField.SummaryVariation Property

Specifies how a summary value that is calculated against the current data field is represented in a data cell.

Declaration

property SummaryVariation: TcxPivotGridSummaryVariation read; write; default svNone;

Property Value

Type	Default
TcxPivotGridSummaryVariation	svNone

Remarks

Options include:

Value	Meaning
svNone	The summary value is displayed “as is”. No variation or percentage is calculated.
svAbsolute	The absolute variation between the current value and the previously calculated value is displayed (corresponds to the absolute variation mode).
svPercent	The percentage difference between the current value and the previously calculated value is displayed (corresponds to the percentage variation mode).
svPercentOfColumn	The percentage of column totals is displayed (corresponds to the percentage mode).
svPercentOfRow	The percentage of row totals is displayed (corresponds to the percentage mode).

To specify the formatting settings for summary values, use the field’s DisplayFormat property.

The following image displays three data fields that are bound to the Quantity field. For these fields, the SummaryVariation property is set to svNone, svAbsolute and svPercent, respectively.

The value in the cell (BMW: 530i – Visa – Qtr2 – Qty (Absolute)) is calculated as follows: 3 = 15-12, where 15 is the actual summary value calculated against the Qty field for BMW: 530i, Visa, Qtr2, and 12 is the previous summary value (BMW: 530i, Visa, Qtr1).

The value in the cell (BMW: 530i – Visa – Qtr2 – Qty (Percent) is calculated as follows: 25% = 0.25 = (15-12)/100. In this variation mode, the values are automatically formatted as percents, so the cell displays ‘25.00%’ instead of ‘0.25’.

The following image displays three data fields that are bound to the Quantity field. For these fields, the SummaryVariation property is set to svNone, svPercentOfRow, and svPercentOfColumn, respectively.

The value in the cell (BMW: 530i – AmEx – February 2002 – Qty (% of Row)) is calculated as follows: 87.5% = 0.875 = 14/16, where 14 is the actual summary value calculated against the Qty field for BMW: 530i, AmEx, February 2002, and 16 is the total summary value for this row (BMW: 530i, AmEx). In this mode, the values are automatically formatted as percents, so the cell displays ‘87.50%’ instead of ‘0.875’.

The value in the cell (BMW: 530i – AmEx – February 2002 – Qty (% of Col)) is calculated as follows: 58.33% = 0.583(3) = 14/24, where 14 is the actual summary value calculated against the Qty field for BMW: 530i, AmEx, February 2002, and 24 is the total summary value for this column (BMW: 530i, AmEx, February 2002). In this mode, the values are automatically formatted as percents, so the cell displays ‘58.33%’ instead of ‘0.5833’.

The default value of the SummaryVariation property is svNone.