Rank

Use the “Rank” calculation to compute rankings for the specified measure:

• Rank along – specifies a window and direction used to rank values;
• Rank type
  • Unique
  • Competition
  • Dense
  • Modified
  • Percentile
• Order – ranking order
  • Ascending
  • Descending

Below we can see the table that displays the ranking of sales for particular years in descending order: