Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
I have written 4 separate set expression for displaying top 3 sales performer country wise .
But can we have a single set expression to achieve same .
Hi,
see Attachment.
Regards,
Antonio
Thank Antonio for resolution .
But you have used pivot table and i see that some employee even though have highest sales are not on top or 1st record .
I was expecting a set expression producing above result
Hello!
The expression will be:
if(aggr(rank(Sum(Sales)),Country,Emp_Nbr)<4,Sum(Sales))
and remove sorting checks to get correct sorting:
See new attachment