I was wondering if you might be able to help point me in the right direction as I seem to have hit a wall. I am building a model which appears to have a linear hierarchy SKU-> Product -> product Family and this is working as expected.
However in part of the model I need to work out component requirements in which we currently take the monthly figure then multiply it by a percentage per component. The problem I'm having is that to be able to do this I feel I need to change my hierarchy but as soon as I do that the levels below can't map he current level and I need the figures from the existing hierarchy to get my solution. e.g. Jan 10,000 is made up of part A 60% and part B 40% I want to be able to show that at product family level we need 6000 Part A and 4000 Part B
I'm just a bit stumped and I'm looking for possible suggestions that might get me moving on it.
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.