how to display latest message in report

Summary:

We are building a Service Request Dashboard , in that want to display the messages also.

When we combine the SR subject Area and SR Messages Subject are , it is giving record duplicate data.

Ex: If a SR-0001 is having 4 conversations then in the report it is giving 4 columns , for each message it is displaying the different row.

Here we want to display only latest updated message(Last updated/posted) message.

Content (please ensure you mask any confidential information):

tried the SQL like below:

1) order by "Service Request Message"."Last Update Date" desc limit 1

2)And in the filter of Last updated date , used the max condition : MAX("Service Request Message"."Last Update Date")