Hello
I have a line-chart where I would like to show top5 and bottom5 sellers.
I have tried to use this code under the expression tab:
1. if(rank(sum(Fortjeneste),4)<=5, sum(Påkost),if(rank(-sum(Fortjeneste),4)<=5, sum(Påkost),0))
2. if(rank(sum(Fortjeneste),4)<=5, sum(Innpris),if(rank(-sum(Fortjeneste),4)<=5, sum(Innpris),0))
3. if(rank(sum(Fortjeneste),4)<=5, sum(Fortjeneste),if(rank(-sum(Fortjeneste),4)<=5, sum(Fortjeneste),0))
4. if(rank(sum(Fortjeneste),4)<=5, count(Fortjeneste),if(rank(-sum(Fortjeneste),4)<=5, count(Fortjeneste),0))
As you understand I have a cyclic group of 4 lists that one can change from the chart.
I have two dimensions, one for sellers, and one for the period of time.
But it ignores my ranking, and show all 20 sellers in the chart, it looks quite messy.
How can I reduce it to top5 and bottom5 sellers?
Kind regards
Espen
