Stop incidents duplicating when joining to threads

Summary:

I have a basic queues report counts the volume of open incidents by queue and date. It has a drill down filter that then lists the incident in detail its ref and other incident level info. I also want to get the first 3 thread text by sequence number column by column not row by row. Just so it clear how many incdinets there are and no duplication happens

I have obviously joined the threads table but im getting duplication based on the number of threads.

I have tried if(threads.seq=1,threads.text), if(threads.seq=2,threads.text), if(threads.seq=3,threads.text), and it works in the sence iputs the right values in the columns, but it still puts down multiple rows. I have done a screenshot of the key part of the report definition below