Display only row with latest date in Straight Table

[Brip51]

Hi,

I have a straight table that can have rows with the same "Table Name" (1st col), but they can have different update dates.

I am trying to figure out how to display only the latest updated date .  In the sample below the table named 'Ultimate Loss Ratio (excludes ULAE)' has two Updated Dates.  I want to only display the 10/02/2023 date row.

I have been struggling to figure out how to do this.  I tried FirstSortedValue, but that didn't work.

Any ideas on the best way to do this would be greatly appreciated.

Thanks,

Brian

[tincholiver]

Did you try using max(Date) ?

[Brip51]

Hi,

Yes.  That doesn't display only the row.

Thanks,

Brian

[pallavi_96 · Accepted solution]

Hi,

You can try below expression :

Aggr(Max(Date),Table)

FirstSortedValue(Date(Date,'DD-MM-YYYY'), Aggr(Max(Date), Table))

[Brip51]

Hi,

Yes.  That worked.  Thank you for the help on this !!!

Regards,

Brian