Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Perhaps this as title?
FirstSortedValue(DISTINCT Country, -Aggr(Sum({<Month = {">=$(=AddMonths(Max(Month),-9))<=$(=Max(Month))"}>} sales), Dim1, Dim2..), 3)
=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
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
Hello Channa, thank you for your reply. Tried the expression but doesn't come out...If you have any idea i could try.
Patrick