How to I pickup latest date row in my report?

[dprogrammer]

How to pick up highlighted rows?

ID    NAME     AMOUNT     DATE

1       CA          1000              2022-05-01

1       CA          1000              2022-05-02

1       CA          1000              2022-05-03

2       CA          1000              2022-05-01

2       CA          1000              2022-05-02

I created a variable on ID+NAME+DATE, then created a variable with MAX(DATE) and reset it on the group but its doesn't seem to be working