Find Rank in Microsoft Report
- by Alex Essilfie
Is there any way I can find the rank of a set of values in Microsoft Reports?
For instance, in order to produce a table like the one below, what function/formula do I enter in the Rank column?
+------+-----+
|Value | Rank|
+------+-----+
| 12 | 3 |
| 30 | 5 |
| 5 | 1 |
| 10 | 2 |
| 24 | 4 |
+------+-----+
Update
Values in the value column are produced from calculations on the report-side so I cannot find the rank using a query.