Show only the row with max date

[FlaminioIta88]

Hello everybody,

I have a situation like this table: due to a dirty DB, for the same items (in this example, item A123) I have 3 different End Version.

I know that the right End Version is the highest (in this example '999999999999999999') but the table show 3 rows showing all the 3 existing value.

I just want the row with "9999999999999".

How can I do it? I tried to write "Max(EndVersion)" but it didn't solved the problem.

Thanks

# item	End Version
A123	999999999999999999
A123	2022052800
A123	2023030100

[Aditya_Chitale · Accepted solution]

Try:

Aggr( max(EndVersion) ,"# item")

Regards,

Aditya

[FlaminioIta88]

Thank you very much!