Applying ranking (Analysis Services only)

Ranking highlights and numbers the top or bottom 1, 2, 5, 10 or 25 values of an Ad-hoc report, the top or bottom values of the columns or the top or bottom values of the rows.

To apply ranking in a report:

  1. Press F4 to display the Properties pane.
  2. Select a ranking option from the Ranking Type field.
  3. Specify the number of values in the Ranking Count field.
    The ranked values are highlighted and numbered.