Filter transactions based on top approved date

Hi Community!

Little help needed:

I have a table with transactions, that have the following columns:

level, company, date, type, value and final.

What I want to do, is filter based on the top yes value on Final based on date, and bring all events on the date and below for that level, company.

What would be the best way to archieve this? Attached an example of the start point and desired outcome.

Thanks for the help! :pray:

example data.xlsx