how to find top 3 highest paid employee from different department using set analysis

[Anonymous]

how to find top 3 highest paid employee from different department using set analysis

[shiveshsingh]

Try This

=aggr(sum({<Name = {"=Rank(Sum(Salary))<=3"}>}Salary),Dept)

[sunny_talwar]

I don't think you need set analysis here... I think you need FirstSortedValue function...

FirstSortedValue(Employee - Aggr(Sum(Salary), Employee), 1)

FirstSortedValue(Employee - Aggr(Sum(Salary), Employee), 2)

FirstSortedValue(Employee - Aggr(Sum(Salary), Employee), 3)

[shiveshsingh]

Nice