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:
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 |