Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have two fields
manager ,sal
now i want to show top 10 mangers in list box.
please help on
Tha nks,
any one
in the list box on the general tab, change the 'field' to 'expression' (last in the list) and enter this:
=if( aggr( rank( sum( Salary)),Manager) <=10, Manager)
Try this Expression:
Sum({$<YourManagerFieldName={"=Rank(Aggr(Sum(YourSalaryFieldName),YourManagerFieldName))<=10"}>}YourSalaryFieldName)
Regards
Aviral Nag