I am having some difficulty figuring out how to get the top 10 of a group.

 

Basically, I have a database with securities, holders, units held.

 

I have my report working fine if I limit to a single security in the record selection, but when I try to run it across the whole DB, I get the top 10 for the whole table instead of the top 10 for each security.

 

I have one group, on the security number. Currently, I have a formula that checks the units held field and displays "top10" if the record is in the Nthlargest for the DB.

 

I believe this is why it is not working for the whole db but I'm not sure how to evaluate each group in the formula.

 

Any help will be greatly appreciated. Thanks!