allocation to keep totals to 100%
Hi Ana planners,
Is there any way to keep the totals at 100% despite applying CAGR to set of percentages.
Image 1 shows the initial percentages and image 2 shows the new percentages after applying CAGR.
FY18 % are my base in image 1 on which CAGR is applied for an occasion called Party for subsequent years.
But the idea is to keep the totals to 100% despite the CAGR increases.
Can some one suggest a way to do it?