how to let report only show one record which contains same incident ref?

Summary:

I have a report with a filter incident.status = solved, so the report will shows solved incident and agent name who solve it, but sometimes incidents reopened and solved more than one times. So the report will shows like this:

solve time                agent name           incident_ref

18:00               A                   240723-000001

13:00               B                   240723-000001

15:00               C                   240723-000001

18:00               A                   240723-000002

11:00               D                   240723-000002

15:00               C                   240723-000002

How to remove duplicate records and only shows like this?

solve time                agent name           incident_ref

13:00               B                   240723-000001

11:00               D                   240723-000002

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):