Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
I don't think multiplying by Avg(1) is needed, this should be enough in itself
Aggr(Rank(Sum({<Company = >} Amount)), Company)
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
I don't think multiplying by Avg(1) is needed, this should be enough in itself
Aggr(Rank(Sum({<Company = >} Amount)), Company)
Sunny, thank you very much for the help. It worked!
Regards!
Mike, thanks for the help. I was helpful!
Regards!