This content has been marked as final.
Show 4 replies
-
Re: Rank in Chart: KPI
Michael Reagan Jul 19, 2017 5:44 PM (in response to Mart�n Caruso)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
-
Re: Rank in Chart: KPI
Sunny Talwar Jul 19, 2017 7:14 PM (in response to Michael Reagan)I don't think multiplying by Avg(1) is needed, this should be enough in itself
Aggr(Rank(Sum({<Company = >} Amount)), Company)
-
Re: Rank in Chart: KPI
Mart�n Caruso Jul 20, 2017 10:02 AM (in response to Sunny Talwar )Sunny, thank you very much for the help. It worked!
Regards!
-
-
Re: Rank in Chart: KPI
Mart�n Caruso Jul 20, 2017 10:03 AM (in response to Michael Reagan)Mike, thanks for the help. I was helpful!
Regards!
-