corelibraries-devexpress-dot-data-dot-pivotgrid.md
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.v25.2.Core.dll
NuGet Packages : DevExpress.PivotGrid.Core, DevExpress.Win.Navigation
[ResourceFinder(typeof(ResFinder), "PropertyNamesRes")]
public enum PivotSummaryDisplayType
<ResourceFinder(GetType(ResFinder), "PropertyNamesRes")>
Public Enum PivotSummaryDisplayType
| 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 PivotSummaryDisplayType values:
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.
See Also