Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

top three name who have highest sal

=Concat(if(Aggr(rank(sum(SAL)),ENAME>=3),ENAME,','))

not working

1 Reply
Gysbert_Wassenaar

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,', ')


talk is cheap, supply exceeds demand