Outstanding Qty by Week

Good day,

I am rephrasing my question form my previous post.

I have three tables, Sales Table, Shipment Table, and Date Table.

What I needed to achieve is the outstanding qty by week.

Outstanding Qty: Please refer to the photo above as guide.

Week is from the Date Table.

For week1, We received an order of 500,000 and we did not ship anything. The outstanding qty is 500,000.

For Week2, we received an order of 300,000. It is added to the outstanding qty(500,000). So the outstanding qty for week2 is 800,000 but we shipped twice for week2 (150,000 and 100,000) so they will be deducted to the total outstanding qty of week2. The final outstanding qty is 550,000 [800,000(150,000 +100,000)].

For Week3, we did not receive any order and we did not ship. The outstanding qty is still 550,000.

For Week4, we did not receive any order but we shipped 250,000. It is deducted to the week3 outstanding qty. The outstanding qty is 300,000 (550,000 - 250,000).

For Week5, we still did not receive an order but shipped 100,000. The outstanding qty is 200,000 (300,000 - 100,000).

An so on...

When I choose a year form my slicer, we can see the outstanding qty of the chosen year by week. (For comparison and record purposes).

I we will check the data attached, there is also a description of an order where they also want to trace the outstanding qty.

We need to achieve this using the table visual only and not the matrix visual.

Stuck for weeks with this. :(

Mussaenda