Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
This?
thanks for reply
the region will be unique and he will select client like this
region rank
1 2
2 3
This?
thanks i will test it
Sounds good
good morning
didn't work
he still Rank for the all region not in the same region
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
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)