Display top 5 threads associated with each Incident in a custom report

Summary:

We have created a custom report to display the Incidents and their threads in a custom report. Each incident can be associated with multiple threads. Hence, we want to display the incidents with only last 5 threads (messages)

Content (please ensure you mask any confidential information):

We have created a custom report to display the Incidents and their threads in a custom report. Each incident can be associated with multiple threads. Hence, we want to display the incidents with only last 5 threads (messages) as shown below

incident id1 Thread1

incident id1 Thread2

incident id1 Thread3

incident id1 Thread4

incident id1 Thread5