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.

    SummaryDisplayType_RankInColumnLargestToSmallest

  • 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.

    SummaryDisplayType_RankInColumnSmallestToLargest

  • 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.

    SummaryDisplayType_RankInRowLargestToSmallest

  • 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.

    SummaryDisplayType_RankInRowSmallestToLargest