Rank in the title

[paddy64]

Good evening, anybody knows how i can put, in the title expression of a chart, the rank of a special dimension?

Eg :Have 9 countries with 9 amount of sales. England is the 3rd on ranking. Want to put on the title something like : "Englands is the 3rd country regarding sum of sales".

Thank you very much lads for help

[Anil_Babu_Samineni]

Perhaps this as title?

FirstSortedValue(DISTINCT Country, -Aggr(Sum({<Month = {">=$(=AddMonths(Max(Month),-9))<=$(=Max(Month))"}>} sales), Dim1, Dim2..), 3)

[Channa]

=If(Aggr(Rank(Sum(CUSTOMS_VALUE_QAR)),COUNTRY_NAME_EN)=3,COUNTRY_NAME_EN)

it shows country name dynamic rank=3

If(Aggr(Rank(Sum(CUSTOMS_VALUE_QAR)),COUNTRY_NAME_EN)=3,COUNTRY_NAME_EN) & '3rd country'

try like this

[paddy64]

Hi Lovisfail, and thank you for your trial.

I tried your expression as follows, but no rank is coming out, though the expressions seems OK . Maybe the end of expression?  

FirstSortedValue(DISTINCT Country, -Aggr(Sum({<Month = {">=$(=AddMonths(Max(Month),-9))<=$(=Max(Month))"}>} sales), Country)3)

Thank you in advance

[paddy64]

Hello Channa, thank you for your reply. Tried the expression but doesn't come out...If you have any idea i could try.

Patrick