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.2.Core.dll
Declaration
[TypeConverter(typeof(EnumTypeConverter))]
[ResourceFinder(typeof(ResFinder), "PropertyNamesRes")]
public enum PivotSummaryDisplayType<TypeConverter(GetType(EnumTypeConverter))>
<ResourceFinder(GetType(ResFinder), "PropertyNamesRes")>
Public Enum PivotSummaryDisplayTypeMembers
| 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.