1 Reply Latest reply on Sep 15, 2015 12:11 PM by Tracy Rodgers

    What-If Calculation

    Scott Shaffer

      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.

       

       

       

       

      Thanks!