Rank client in the same region

[bbmmouha]

hello

i have a problem whith Rank.

i have this exemple

region        client         sum(sels)   

1               1               20

1               2               30

1               3               15

2               1               20

2               2               40

2               3               60

what i want is the rank of client in the region not in different region

for exemple rank client 1 in region 1 is 2

                  rank client 1 in region 2 is 3

thanks for help

[sunny_talwar]

This?

[bbmmouha]

thanks for reply

the region will be unique and he will select client  like this

region             rank

1                      2

2                      3

[sunny_talwar]

This?

[bbmmouha]

thanks i will test it

[sunny_talwar]

Sounds good

[bbmmouha]

good morning

didn't work

[bbmmouha]

he still Rank for the all region not in the same region

[bbmmouha]

what i wont is the rank of the selected client in the region

if i add the client as a dimention this will be ok but i have so much clients and the table will be not readable

any helps please

[sunny_talwar · Accepted solution]

This?

The problem you will run into is that when you don't have any client selected it will show null

If that is acceptable then use this expression: =Aggr(If(Sum(Sales) > 0, Rank(Sum({<client>}Sales))), region, client)