How to get top 10 and bottom 10 (say based on Rank in an exam) in the same report ?
Any way to do this report studio ?
Regards
Jf
Sure. Is this relational or dimensional?
In relational, you can create two queries, both filtered for [rank]<=10, and [rank] is a rank function descending for the top 10 and ascending for the bottom 10. Then union the queries, and you're golden.
Over dimensional you can use the topcount and bottomcount functions for the same effect.
Thank you... :)