Calculate value of previous days, where value changes by time.

[insandur]

I have a table with below columns where backlog number keep on changing everday and i want to capture the previous days backlog till last 2 week.

Backlog: 150

Received Date	Shipments	Backlog
2/14/2023	AXB	100
2/14/2023	AXC	50

Next day Backlog : 50

Received Date	Shipments	Backlog
2/15/2023	AXB	0
2/15/2023	AXC	0
2/15/2023	AXD	50

Now i want to see the backlog of today as 50 and previous day backlog as 150.

Expected : eg

Received Date	Backlog
2/14/2023	150
2/15/2023	50

Thank you.

[tamerj1]

@insandur 
Please clarify the expected results with examples.