Rank

[Anonymous]

Hi,

I want to show rank top of a client, based on Sales. Can i do this with set analysis? I am trying rank(aggr(sum(Sales),[NameClient])), but when i select a client it shows 1. I need to be able to select a client and to show the rank between the rest of the clients.

Any suggestions?

Best regards,

Cosmina

[sunny_talwar]

Can you share few rows of data and point out the expected ouput?

[lironbaram · Accepted solution]

hi

you can use set analysis in your rank

if you display a table with customer rank

this should do the trick

max(aggr(rank(sum({<NameClient=>}Sales)),NameClient))

[vinieme12]

TRY

AGGR(NODISTINCT rank(SUM({1}Sales),1,1),[NameClient])

[#5]

Try this

rank(sum({<NameClient=>}Sales))

[Anonymous]

Thank you all,

I tested

max(aggr(rank(sum({<NameClient=>}Sales)),NameClient)) and works.

Best regards,

Cosmina