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:
Show More
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 |
Show Less
Posted: 7 years ago
Pegasystems Inc.
Pegasystems Inc.
IN
Hi Yang,
You can use custom sql function for your report definition as explained in below link:
https://docs-previous.pega.com/how-create-custom-sql-functions-reporting
Regards,
Vikash