Skip to main content

FieldSummaryDisplayType Enum

Contains options that specify how summary values are displayed within cells (“as is” or adjusted using a specific predefined algorithm).

Namespace: DevExpress.Xpf.PivotGrid

Assembly: DevExpress.Xpf.PivotGrid.v24.1.dll

NuGet Package: DevExpress.Wpf.PivotGrid

Declaration

public enum FieldSummaryDisplayType

Members

Name Description
Default

The calculated summary values are displayed “as is”.

AbsoluteVariation

The absolute variance between the current value and the previously calculated value for the current field is displayed in the cell.

PercentVariation

The percentage variance between the current value and the previously calculated value for the current field is displayed in the cell.

PercentOfColumn

For data cells, the percentage of the column’s total value is displayed; for total cells, the percentage of the column’s grand total value is displayed.

PercentOfRow

For data cells, the percentage of the row’s total value is displayed; for total cells, the percentage of the row’s grand total value is displayed.

PercentOfColumnGrandTotal

Percent of the summary in the Column Grand Total value.

PercentOfRowGrandTotal

Percent of the summary in the Row Grand Total value.

PercentOfGrandTotal

Percent of the summary in the Grand Total value.

RankInColumnSmallestToLargest

The summary value’s rank in its column, with the smallest value in the column as 1, and each larger value assigned a higher rank.

RankInRowSmallestToLargest

The summary value’s rank in its row, with the smallest value in the row as 1, and each larger value assigned a higher rank.

RankInColumnLargestToSmallest

The summary value’s rank in its column, with the largest value in the column as 1, and each smaller value assigned a higher rank.

RankInRowLargestToSmallest

The summary value’s rank in its row, with the largest value in the row as 1, and each smaller value assigned a higher rank.

Index

An index value that reflects the summary value’s importance in its row and column context. This value is calculated as follows:

((value in cell) x (Grand Total of Grand Totals)) / ((Grand Row Total) x (Grand Column Total))

Related API Members

The following properties accept/return FieldSummaryDisplayType values:

Remarks

Refer to the following help topic for information on how to use summary display types in Optimized mode: Summary Display Types.

Use the PivotGridField.SummaryDisplayType property of the FieldSummaryDisplayType type, to specify how summary values are displayed within cells in Legacy and LegacyOptimized modes.

See Also