Need row level calculations

Hi All,

I need a calc which can give me Approve total bookings amount based on the max date of each Si no. I have attached the sample file.

Please help to get this.

Regards