How to filter in a normal table in Qlik Sense

[paulb1981]

Suppose I have the following data:

Company	Update	Person
A	10-Oct-2023	John
B	4-Sep-2021	Lisa
B	8-Nov-2019	Hank
C	4-Feb-2022	Pete
D	10-Dec-2022	Karen
D	1-Jan-2020	Steve
E	5-Sep-2023	Michael

But I only want to show the most recent update date for each company. So, I want this table. 

Company	Update	Person
A	10-Oct-2023	John
B	4-Sep-2021	Lisa
C	4-Feb-2022	Pete
D	10-Dec-2022	Karen
E	5-Sep-2023	Michael

Ideally, both 'Company' and 'Person' are dimensions, whilst 'Update' is a measure.

How do I get to this result? I can the date to use '=max(update)', but then I don't get a person in the table. I've tried many other functions (firstsortedvalue, aggr, only, distinct) as well, but I haven't solved it.

[Mark_Little]

Person would have to be a measure as well, Something like

Try first

ONLY(Person) 

I suspect it will need a set expression to

Only({<Update={"=Max(Update)"}>}Person)

[CHRIS_Singa]

essayez avec un dollar $

{"$(=max(Update))"}

[paulb1981]

Thanks. This works for a few in my dataset (which is bigger than the one above), but strangely not for most of them.