PivotSummaryDisplayType Enum
Contains options that specify how summary values are displayed within cells (“as is” or adjusted using a specific predefined algorithm).
Namespace: DevExpress.Data.PivotGrid
Assembly: DevExpress.PivotGrid.v18.1.Core.dll
Declaration
[TypeConverter(typeof(EnumTypeConverter))]
[ResourceFinder(typeof(ResFinder), "PropertyNamesRes")]
public enum PivotSummaryDisplayType
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 PivotSummaryDisplayType values:
Remarks
Use the PivotGridFieldBase.SummaryDisplayType property of the PivotSummaryDisplayType type, to specify how summary values are displayed within cells. For more information see Summary Display Modes.
Related GitHub Examples
The following code snippets (auto-collected from DevExpress Examples) contain references to the PivotSummaryDisplayType enum.
Note
The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.