Use Custom Ranking

By default, ranking is based on the innermost nested set and calculates the items that meet the filter criteria in the selected row or column. To calculate rank using different segments of the data or the outermost set, use custom ranking. For an example of custom ranking, see.

Procedure

  1. Select a row or column to rank.
  2. Click the calculate button calculate icon on the toolbar.
  3. Click Custom.

    The Calculate dialog box appears.

  4. In the Operation type box, click Ranking.
  5. Under Rank, click Custom.
  6. Choose the options that you want:
    • Specify whether to rank the highest value or the lowest value as number 1.
    • Change the scope of the rank, such as by ranking only within visible items.
    • Rank by the innermost or outermost nested set in a crosstab.
  7. Click OK.

Results

You can now sort the rank results to show them in numerical order.

Parent topic: Rank Values