wpf-devexpress-dot-xpf-dot-pivotgrid-d497bb89.md
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.v25.2.dll
NuGet Package : DevExpress.Wpf.PivotGrid
public enum FieldSummaryDisplayType
Public Enum FieldSummaryDisplayType
| 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))
|
The following properties accept/return FieldSummaryDisplayType values:
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