Formula to take 1 unit data to another
I am trying to create a model to summarize the volume from the region and paste back into manufacturing unit, not sure what formula should work in this situation.
For example, Australia (Reporting Unit) and New Zealand (Reporting Unit) purchase plastic cup from Hong Kong (Manufacturing Unit) by 300 cases, I want to put this 300 cases back into Hong Kong (Reporting Unit). How can I create the formula to pick up all the demand 300 cases under Hong Kong (Reporting Unit) ??