Rank question based on selection

[alexpanjhc]

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