Targeted Value with Changing Mix
I have (2) dimensions with values in (2) years, which sum to a total value for each year. The mix of those values from year 1 to year 2 changes. I want to input a hypothetical value total and the formula to return the “should be” mix for each of the (2) dimensions.
Example:
Year 1
Consulting is 14,000 (30% of total)
Distribution is 33,000 (70% of total)
Total is 47,000
Year 2
Consulting is 15,710 (18% of total)
Distribution is 69,290 (82% of total)
Total is 85,000
Hypothetical
Consulting is XX,XXX (XX% of total)
Distribution is XX,XXX (XX% of total)
Total is 72,500 (I enter this value and the formulas provide the XX results above)
I have (2) dimensions with values in (2) years, which sum to a total value for each year. The mix of those values from year 1 to year 2 changes. I want to input a hypothetical value total and the formula to return the “should be” mix for each of the (2) dimensions. Example: Year 1Consulting is 14,000 (30% of total)Distribution is 33,000 (70% of total)Total is 47,000 Year 2Consulting is 15,710 (18% of total)Distribution is 69,290 (82% of total)Total is 85,000 HypotheticalConsulting is XX,XXX (XX% of total)Distribution is XX,XXX (XX% of total)Total is 72,500 (I enter this value and the formulas provide the XX results above) Read More
