The Rank function returns the rank of a number in a column of numbers. It works as if you were to sort the list in descending order.
numbers references the column that contains the numbers on which the rank is calculated.
break_col is an optional parameter that references a break column.
The Rank function assigns duplicate numbers the same rank. The presence of duplicate numbers affects the ranks of subsequent numbers. |
The following examples show the results of inserting the Rank function in two separate tables.
In this example, the Rank function is used for the numeric column (the column that contains the numbers to rank). The results are shown in the Computed column.
Rank(Amount)