Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to find top 3 highest paid employee from different department using set analysis
Try This
=aggr(sum({<Name = {"=Rank(Sum(Salary))<=3"}>}Salary),Dept)
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)
Nice