I have this request:
we have 10 businesses and 1000 +different clients.
I can correctly display the ranking in KPI however, the ask is that if the user select another business, what the ranking of the client in that business.
for example if i am showing client C's rank with in its business it is #1
but if i selected a dropdown box of Business of Manufacture it should be #3
there is only one table and the ranking is used
aggr(rank(Sum({<Year={$(v_CY)} , Date = {"<=$(=Max([Date]))"} >} Sales) ,1,1), [Business ,[Client Name])
how do i achieve this?
| Client |
Business |
Sales |
Ranking
|
| A |
Manufacture |
100 |
1
|
| B |
Manufacture |
20 |
2
|
| C |
Retail |
1 |
2
|
| D |
Financial |
400 |
1
|
| E |
Financial |
200 |
2
|
