Rank and sort

[thomas_skariah]

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

[marcus_sommer]

Maybe with a logic like: maxstring(Rank & ID) in a sort-expression.

- Marcus