Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
=Concat(if(Aggr(rank(sum(SAL)),ENAME>=3),ENAME,','))
not working
The highest sales will have rank 1, the second highest gets rank 2. So instead of >= you need <=.
=Concat(if(aggr(rank(sum(SAL)),ENAME)<=3, ENAME),', ')
Or perhaps better like this:
=Concat({<ENAME={'=rank(sum(SAL))<=3'}>}ENAME,', ')