What should be Single set expression for showing top 3 country wise ?

[shekhar_analyti]

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 .

[antoniotiman · Accepted solution]

Hi,

see Attachment.

Regards,

Antonio

[shekhar_analyti]

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

[Sergey_Shuklin]

Hello!

The expression will be:

if(aggr(rank(Sum(Sales)),Country,Emp_Nbr)<4,Sum(Sales))

and remove sorting checks to get correct sorting:

[antoniotiman]

See new attachment