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.v23.2.dll
NuGet Package: DevExpress.Wpf.PivotGrid
Declaration
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.