Hello all,
I have a tricky point, and cannot succed to solve it.
There is Confirmed orders (already sold) and Forecast orders (we produce in advance because we think we need to have some stock for many reason).
My company will produced all the quantities, but not exactly at the correct weeks (sometimes late, sometimes in advance).
=> cf figures in green below
My need is to detail my production Qty : was it done for Confirmed Orders or Forecast Orders ? (or both)
No need to precise when was the orginal need, if I have delay or whatever.
=> cf figures in blue below
My production Week 1 is enough for all my need of week 1 and week 2 (20 Conf. Orders and 10 Fcst Orders)
My production Week 2 is enough for a part of my Fcst Orders need week 3 (the previous week needs has been already served by my production week 1).
etc
(I hope the use case is clear)
So to have the blue result : I cannot succeed to find any way, either using cumulate or whatever.
Is any Anaplaner has a good idea for me on this ?
Many thanks !
