Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am looking for a set analysis in order to show in a table only the first 5 company with the biggest (max) values.
Company Values
A 100
B 99
C 99
D 97
E 96
All the rest of the companies shouldn't showing up,
Thank you for any help
Best
Try this:
if(Aggr(Rank(Sum(Value)),Company ) <=5,Sum(Value))
Thanks for the answer.
Can you please give to me a bit more details?
Best
Try this:
if(Aggr(Rank(Sum(Value)),Company ) <=5,Sum(Value))
Sorry again,
If I also would like to have the lowest 5? what will change in the formula?
Try this 🙂
if(Aggr(Rank(-Sum(Values)),Company) <=5, Sum(Values))
Works perfectly.
Thanks a lot 🙂
You are welcome 🙂