Hi Everybody,

I would like to breack down expectations per Customers, knowing that Customer B will grow 200% more than A and C. The Total expectation is allready fixed by calculating CAGR and should stay as is.

I tried with different formulas but no matter how I did, the total "Expectation 2020" did not match the sum.
Please, see the Pictures attached.
Growth Factor.PNG


Any Idea how I can do this?

Many thanks for you help
Suzanne