Question

4
Replies
403
Views
YangD245 Member since 2017 31 posts
Tata Consultancy Services
Posted: 2 years ago
Last activity: 2 years 2 months ago
Closed

Top N records for each group of records

How can report definition fetch top N record/s for each group of records? For example, a list report definition fetches below records.

SNNameSubjectScore
1AMath100
2AScience90
3BMath88
4BScience99

The requirement is to get only one record for each name that has the highest score and Report Definition result should look like below:

SNNameSubjectScore
1AMath100
4BScience99
Reporting
Moderation Team has archived post
Share this page LinkedIn