I am making some combo chart with :
- fiscalmonth_plan as the dimension,
- original order plan qty as bar chart,
- montly actually finished qty as one line,
- I expect the delayed qty over month can be added into the total plan of next months, depending on the actual finished month it ends. And finally the delayed line can be like red lines as below photo showed. Can you help here? many thx!
Also please refer to attached excel list for your further information here, with notes as following:
Delayed qty actually is dynamically based on the [Actual Finishing Date], here I just put the difference (between order-finished) into next month for explaining.
BUT, the expectation is, e.g if the fiscalmonth([Actual Finishing Date]) is 3 months later than Fiscalmonth_plan, then the total plan in following three months shall all contains this delayed quantity as too.
thanks for your time.
let me explain, e.g. in case of one order with [required date] as 2018/09/05, but it was actually finished on 2018/12/15. So besides the original planned orders monthly, for following planned months like Oct, Nov, Dec, shall all contains this delayed order qty as delayed qty. hope it make sense now.
I am still stuch with above question, can someone help me out here?
If to add the delayed orders all into next month would be using above(), but here delayed orders could possilbly span over serveral following months, which is my bottleneck here, any funtions or expression can be used?
If any questions, kindly please let me know.
Very appreciated for the support!
Dear expert, this issue has been pending for near 2 weeks for me , I believe ceating reference dates would the solution here. but how to use iterno() here for the dimension in fiscalmonth instead of day in the scripts writing in details? kindly please direct and intruct here, thanks in advance