Rank group wise values for multiple dimension in straight table

Sri4 — Mon, 10 Jul 2023 14:00:31 GMT

I have data , I want rank each dimension by group the values .

abcd:
Load *
Inline [

Name,City,State
Ab,Hyd,Ts
Ab,Hyd,Ts
Ab,Mum,Mh
Cd,Mum,Mh
Cd,Mum,Mh
Xy,Kol,Bg
];

I got output

Expecting output:

Re: Rank group wise values for multiple dimension in straight table

FrankG — Tue, 11 Jul 2023 09:20:28 GMT

You can try this:

Add this to the loadscript:
Load *, rowno() as row

And for the ranking expressions:
aggr(rank(-row), Name, row)
aggr(rank(-row), Name, City, row)
aggr(rank(-row), Name, City, State, row)