Rank Modes
- 2 minutes to read
Rank summary display modes are used to display summary values’ ranks in their columns and rows.
The following rank modes are available.
PivotSummaryDisplayType.RankInColumnLargestToSmallest
The summary value’s rank in its column, with the largest value in the column ranked as 1, and each smaller value assigned a higher rank.
In the following image, the SummaryDisplayType properties of the two data fields are set to Default and RankInColumnLargestToSmallest respectively.
PivotSummaryDisplayType.RankInColumnSmallestToLargest
The summary value’s rank in its column, with the smallest value in the column ranked as 1, and each larger value assigned a higher rank.
In the following image, the SummaryDisplayType properties of the two data fields are set to Default and RankInColumnSmallestToLargest respectively.
PivotSummaryDisplayType.RankInRowLargestToSmallest
The summary value’s rank in its row, with the largest value in the row ranked as 1, and each smaller value assigned a higher rank.
In the following image, the SummaryDisplayType properties of the two data fields are set to Default and RankInRowLargestToSmallest respectively.
PivotSummaryDisplayType.RankInRowSmallestToLargest
The summary value’s rank in its row, with the smallest value in the row ranked as 1, and each larger value assigned a higher rank.
In the following image, the SummaryDisplayType properties of the two data fields are set to Default and RankInRowSmallestToLargest respectively.