Find Rank in Microsoft Report
Posted
by
Alex Essilfie
on Stack Overflow
See other posts from Stack Overflow
or by Alex Essilfie
Published on 2011-01-10T10:56:52Z
Indexed on
2011/01/11
2:53 UTC
Read the original article
Hit count: 245
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.
© Stack Overflow or respective owner
