Question

4
Replies
519
Views
Close popover
Gyan Dahal (YangD245)
Tata Consultancy Services

Tata Consultancy Services
US
YangD245 Member since 2017 31 posts
Tata Consultancy Services
Posted: May 22, 2018
Last activity: July 18, 2018
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.

SN Name Subject Score
1 A Math 100
2 A Science 90
3 B Math 88
4 B Science 99

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

SN Name Subject Score
1 A Math 100
4 B Science 99
Reporting
Moderation Team has archived post,
Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.