Create a record ranking number in a view/report
Hello,
How can I create a record ranking number in a single view or report?
For instance, there is a view or report created with 10 records. Then, I sort those in a certain way, e.g. by date. At that point, I'd like to have a record number in the first column to show me 1, 2, 3, ..., 10. In that case, I may refer to... "Record 5, 7, and 8..." without counting the records/lines on the screen. It could be more complicated, such as "Record 16, 22, and 34...", etc. Then, I may change the sorting, e.g. by % Complete. I want to have the ranking number from 1 thru N (top to bottom), again. And son on and so forth.
Is there a way to add a (static) line/record ranking number column in a view or report with sorting being changed? Thank you.
Best,
+Pavlin