Running total with calculated column

[joshua1990]

Him all!

I have 3 tables:

tbl Article

Article	Average Sales per week
A	500
B	600

tbl Stock

Article	Stock
A	2000
B	6000
C	100

tbl Deliverys

Article	Date	Delivery
A	01.10.2022	500
A	05.11.2022	600
B	06.08.2022	500
B	08.10.2022	400

Now I would like to get a running total chart (weekly) that is starting today based on current stock level and then it summes up the Average sales and the deliveries per week. Past deliverys should be ignored.

How would you do that?

[Greg_Deckler]

@joshua1990 Not certain I am following 100%, what is the expected outcome (as in numbers that you would expect to see)