How to retrieve the rows which has maximum rank for their respective dimension?

[Uzumaki_N]

I want to output as:

I want the rows which has maximun FieldNo for respective Table Column.

Thanks

[chaorenzhu]

if you want output as a straight table, use max(FieldNo) for your FieldNo, and aggr(firstsortedvalue(Field,-FieldNo),Table) for your Field