Please suggest how to get the date while doing the calculation

[avik1986]

I got a requirement where while I am running the report for a day it will consider last selling date and previous last selling date data and the dates are dynamic

suppose I am running report from 18th - 23rd April

and selling had been done on -

22 - 500$
19 - 1000$
18 - 400$
15 - 200$

report should be like

22'Apr - 500+1000
19'Apr - 1000+400
18'Apr - 400+200

Could someone guide how to build this logic as dates are dynamic ans I need to consider previous sales date in the calculation for each sales day