insert line numbers as first column in table/matrix (1,2,3,4)
I would like to insert a column in by table/matrix that gives show a number per line.
Line number - Name - Sales
1 - Robert - 193000
2 - Jen - 185000
3 - Alberto - 181000
100 - Ben - 23000
1. RANKX can be quite slow. Thus, buy having a line number you can easy create a top.
2. In discussion meeting or analysis purpose it can be helpful to know the line number. E.g. checking purpose - "I validated all from 1-1000 row", "I found and issue with line number 40 in todays report"