I would like to create a What-If table that shows the amount of growth needed by a certain set of clients (top X % or top X #) to reach a target growth rate, if the clients grow at a market growth rate.
For example, in the workbook attached, for a specific country, I would like to specify the target and market growth rates (either in a calculated field or parameter), and determine what the top 5 or top 5% of clients need to grow to meet the target. If the rest grow at market rate.
It is much easier to see in the workbook. I have already created calculated fields that specify market and target growth by country
I would like to create a chart similar to this...
It gives the percentage growth needed for the top 5, 10 and 50 clients by region.