Ranking

[Channa]

i am showing top 30 countries by using below expression in GEO map

=If(Aggr(Rank(Sum(CUSTOMS_VALUE_QAR)),COUNTRY_NAME_EN)<=30,COUNTRY_NAME_EN)

measure :sum(sales)

I have second chart by Product wise Sum(sales)

in that second chart i want to show only sales for top 30 countries

any advice

[Channa]

=If(Aggr(Rank(Sum(CUSTOMS_VALUE_QAR)),COUNTRY_NAME_EN)<=30,sum(CUSTOMS_VALUE_QAR))

i tried this expression but dosent work

[sunny_talwar · Accepted solution]

May be try this

Sum({<COUNTRY_NAME_EN = {"=Rank(Sum(CUSTOMS_VALUE_QAR)) <= 30"}>}CUSTOMS_VALUE_QAR)

[Channa]

Perfect bro thank you