Show only the row with max date

FlaminioIta88 — Wed, 13 Sep 2023 07:23:44 GMT

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

Re: Show only the row with max date

Aditya_Chitale — Wed, 13 Sep 2023 07:38:14 GMT

Try:

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

Regards,

Aditya

FlaminioIta88 — Wed, 13 Sep 2023 08:02:46 GMT

Thank you very much!