Order backlog per week

Hi everybody,

i have the following problem. I would like to show the order backlog per week.

The solution should look like this:

I need to have every order in the list per week till the production starts.

For e.g. order RE8821 pops up in calendar week 3 will countinue till week 8, because at the 24.02.21 the production will start.

Another example is RE8997, this one will be in the list every calendar week because there is no production date yet.

My data modell contains two tables, Calendar table with column for date another one for calendar week. My second table contains order number, order entry date, production date and weight. The table are connected by Date (Calendar) and Order enty date.

The second table (Order table) contains two different types of orders. The one order type contains just number, e.g. 105214, this are the real orders and the other one contains RE at the beginning. These are the reservations.

I also would like to have those two are separated.

I hope I have explained my problem clearly.

I am thankfull for every help I get!!

Tendo