Rank Modes

  • 2 minutes to read

Use rank summary display modes when you need to replace raw summary values with their ranks calculated among other values located in the same column or row.

The following modes are available.

  • Value's Position in Its Column, Ranking Values From Largest to Smallest

    Displays the summary value's rank among other values in the same column, with the largest value in the column ranked as 1, and each smaller value assigned a higher rank.

    This mode is specified by the PivotSummaryDisplayType.RankInColumnLargestToSmallest value.

    SummaryDisplayType_RankColumnsLargestToSmallest

  • Value's Position in Its Column, Ranking Values From Smallest to Largest

    Displays the summary value's rank among other values in the same column, with the smallest value in the column ranked as 1, and each larger value assigned a higher rank.

    This mode is specified by the PivotSummaryDisplayType.RankInColumnSmallestToLargest value.

    SummaryDisplayType_RankColumnsSmallestToLargest

  • Value's Position in Its Row, Ranking Values From Largest to Smallest

    Displays the summary value's rank among other values in the same row, with the largest value in the row ranked as 1, and each smaller value assigned a higher rank.

    This mode is specified by the PivotSummaryDisplayType.RankInRowLargestToSmallest value.

    SummaryDisplayType_RankRowsLargestToSmallest

  • Value's Position in Its Row, Ranking Values From Smallest to Largest

    Displays the summary value's rank among other values in the same row, with the smallest value in the row ranked as 1, and each larger value assigned a higher rank.

    This mode is specified by the PivotSummaryDisplayType.RankInRowSmallestToLargest value.

    SummaryDisplayType_RankRowsSmallestToLargest

See Also