You can do this with the help of parameters! you can have your records divided into top 5/10/50 .. and Others and set them in parameters and do the needful.
Refer this article, it will give you exactly what you want:Create Sets for Top N and Others
Hope this helps,
This is very close to what I'm hoping to do. However, I don't want those not in the Top N to be combined into an "other" group, I just want to not see them, then be able to expand the table to see the rest like in the example I provided. Any ideas to "hide" those not in the Top then expand to see them?
Thanks so much!