How to create aggr filter expression

[bubbleT]

Currently I have the "Organisation" and "Submission Date" columns, I want to create a filter that extracts the entry with the latest submission date from each unique organisation.

Desired filter results:

Apple 08-Sep-2023

Banana 22-Aug-2022

How can I create a filter for this?

Thanks in advance!

[Chanty4u]

Try this

=aggr(Max({<Organisation = P(Organisation), [Submission Date] = {"=Max([Submission Date])"}>} [Submission Date]), Organisation)

[Ahidhar · Accepted solution]

try this

=aggr(max([Submission Date]),Organisation)

[Rohan]

Just an addition to this, 

You will have to concat both your columns to get the desired output in a single filter pane. ie :

Organisation &' '&date(aggr(max([Submission Date]),Organisation),'DD-MMM-YYYY')

Regards,

Rohan.