Cumulate a moving target
Hey Anaplanners! Hopefully a fun one and not just my own short-circuiting. I'm working through a capacity allocation rankcumulate, where my list items(SKUs) have a target for a month, and multiple sites that can produce units towards that target. My issue is that the cumulation is correctly grouping by SKU group (family) and site, but each site can't tell whether a SKU's target was met by a prior site, or skipped. I attempted a parallel calculation for target, but ended up with a circular reference as it's the output of the earlier rankings that determine the remaining target. I'm using stepwise, so I can "reset" my target each step, but the same SKU is target seeking multiple times per step. Here's my excel showing in the yellow the SKUs duplicating their targets in step 1, hopefully this gives a better visual than my current blueprint mode.
tldr; The challenge is that I have a capacity limit by P5 and site, but my target is by SKU and region. All help is appreciated :)