Rank in Chart: KPI

[martin_caruso]

Hello! Good afternoon!

I was presented with the following problem and would like to know if anyone could help me.

I have a table with the following values, which is assigned a ranking according to the amount.

Header 1	Header 2
Europe	100
Oceania	20
Africa	40
Asia	80
America	75

On my dashboard, I want you to select a continent (for example, America) in a KPI that ranks # 3.

I am using the ranking function, it shows me ok in the table but doing so in the KPI indicates the value 1.

I look forward to your cooperation.

Thank you very much!

Regards!

[mikecrengland]

I had to do something similar  on a 'Top 100' chart, putting the rank on the axis of the bar chart. The expression is:

Aggr(Rank(Sum({<Company = >} Amount)) * Avg(1), Company)

It keeps the original ranking when you filter to a (or several) companies.

mike

[sunny_talwar · Accepted solution]

I don't think multiplying by Avg(1) is needed, this should be enough in itself

Aggr(Rank(Sum({<Company = >} Amount)), Company)

[martin_caruso]

Sunny, thank you very much for the help. It worked!

Regards!

[martin_caruso]

Mike, thanks for the help. I was helpful!

Regards!