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