Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Top 3:
if(rank(sum(value), 4, 1) <=3, dimension)
Bottom 3:
if(rank(-sum(value), 4, 1) <=3, dimension)
If you want to display in a text box you can do
=concat(aggr(if(rank(-sum(value), 4, 1) <=3, dimension), dimension), dimension & ', ')
can you please explain me why we use 4,1 in synatax
Honestly, mostly because of habit I used this and from how i typically want rank functions i've use this. This impacts when there are ties in ranks and how you want to handle it. I think it's really the 2nd parameter that i'm concerned about. But at this point i go with 1,1 or 4,1 out of habit. 2 in the second parameter doesn't assign all dimension values with the ranks when there are ties. 3 will return 1-2 or 3-5 when there are ties.
thank you
Hi @Vijayqlik4171 please mark this thread appropriately either marking solution or any outstanding issue so the thread can be closed for future community questions that are simliar.
Thanks.