Straight Table - Display the correct row by status

[A7R3]

Hi,

I have a situation that I have many product reports with different timestamps. For illustration, the product table will look like this

Products	ReportDate	Status	Progress
A	1/1/2021	0	90%
A	2/1/2021	1	100%
A	3/1/2021	0	80%
B	1/1/2021	0	90%
B	2/1/2021	0	70%
B	3/1/2021	0	90%

I would like to create a summary report with the following rules:

IF the Product has achieved the status = 1, shows the corresponding ReportDate and Progress. (Ignore the latest ReportDate)
IF the Product hasn't achieved the status = 1 (all Status = 0), shows  the latest ReportDate and Progress. (Ignore the earlier ReportDate)

The result should look like this

Products	ReportDate	Status	Progress
A	2/1/2021	1	100%
B	3/1/2021	0	90%

Appreciate any advice on this. Thanks in advance.

[A7R3]

One thing to mention is that the Progress field is linked to Product field and ReportDate field. So the filter must return the correct ReportDate so that the corresponding Progress will show up correctly.

[A7R3 · Accepted solution]

I manage to solve the problem with IF/Match statement to show the correct rows. Thank you for those who are looking out for this.