How to show top 10 managers in list box?

[#1]

Hi

i want to show top 10 managers in list box

i have salry and manger columns are there now i want to show top 10 mangers in list box

Thanks,

[Gysbert_Wassenaar]

Choose the option <Expression> and use an expression like =aggr(if(rank(sum(salry))<=10,manager),manager). Make sure to use the correct case sensitive field names.

[ecolomer]

[#4]

Hi thanks for giving

but not in chart,pivot,or straight table

i want to show in list box with check box selection

for check box selection

[ecolomer]

You can use the expresion explained by Gysbert Wassenaar

[#6]

i used ur expression

but its showing all the values not top 5 values

[#7]

Thats not giving result

[ecolomer]

here

[#9]

PFA Sample QVW

[#10]

Per the solutions provided, I see that the potential issue is that by using an expression in a listbox you don't have the same listbox functionality (selections/colors) because once a selection is made, the expression is then calculated on the remaining records which changes the output. The ten original records are never shown together when one or more managers are selected, and this may not be the desired response.