Thanks for that, I've attached a sample spreadsheet with a rough layout of what I'm trying to achieve. My main issue is that we need the SKU total from the calculation but the formula is assigned to a level or 2 up. Also in our live data we have multiple SKUs rolling into the same product hierarchy with the same formula. If I make my hierarchy unique for the formula layer which I need to do to get the formula onto Anaplan, I don't then have the hierarchy to roll up. I was thinking of creating a module with a unique reference for each recipe, but have a hierarchy component part in it e.g. unique1, product1, unique2, product1 with a list for the unique code and then create a module using this and time then use the lookup to get the Product total and then the correct percentage for my calculation. does this sound correct or am I wasting my time? Thanks again David
... View more