Group by

Hi everyone,

I am struggling with grouping the below set of data:

1) Firstly, I want to group the highlited columns. My final result should be: one row with date and total amounts for both columns

2) Secondly, I need to group the backlog - need to receive the last value from the last row (31143).

Does anyone know how to solve this?

Thank you!