Need an intersect with setanalysis

[#1]

I want to display the top 10 players for the value Mat/Inns ( Mat divided by Inns)

I tried something like this to start with but doesn't seem to work (no surprise, I'm a novice)

=if ((Mat/Inns)=max(Mat/Inns), Player)

Please help.

Thanks

Ram

[#2]

Use = aggr(if(rank((Mat/Inn))<=10,Player),Player) instead and see the attached QV application

Regards

Mhatim

[#3]

Thanks Mhatim. It did the trick when it came to chart. But I am trying to achieve this in a list box through an expression.

[Gysbert_Wassenaar]

See attached file

[#5 · Accepted solution]

In the list box under the Field use the same expression

Please see the attached QV application.

regards

Mhatim

[#6]

Thanks Mhatim and gwassenaar