Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
From below table can anyone suggest how to get rank column when the values are same and then arrange the rank by alphabetical order based on ID column.
MeterNo | Rank | ID | % |
PC18 | 1 | COX | 25.00% |
VRSS035 | 1 | BL03 | 33.33% |
VRSS035 | 2 | BL04 | 33.33% |
VRSS100 | 1 | BL03 | 33.33% |
VRSS100 | 2 | BL04 | 33.33% |
Regards,
Tom
Maybe with a logic like: maxstring(Rank & ID) in a sort-expression.
- Marcus