2 Replies Latest reply on Aug 1, 2018 1:40 AM by Neel Rajani

    Forecasting with future YoY data with varying Ethnicity and Age groups

    Neel Rajani

      Hi all,

       

      I have data on projections of future age group and ethnicity distributions (years 2015, 2020, 2025 and 2030).

       

      Here is the sample of data available:

       

      Age Distribution Data:

       

      Age Group
      YearNumber of People Physically Active
      13-14201510000
      13-142020500
      13-14202530000
      13-142030345
      15-192015198765
      15-1920204567
      15-1920256543
      15-1920309876
      20-24201556789

       

      Ethnic Distribtuion Data

       

      Ethnicity
      YearNumber of People Physically Active
      A201510000
      B2020500
      C202530000
      A2030345
      B2015198765
      C20204567

       

      The total 'Number of People Physically Active' in 2015 across all age groups is the same as the total 'Number of People Physically Active' in 2015 across all ethnicity. The total 'Number of People Physically Active' goes down from 2015 to 2030 and I would like to have a dashboard that shows how many fewer people per age group & ethnicity are 'Physically Active' compared with the 2015 total.

       

      The output would look like:

       

      I am struggling to recreate this.

       

      Thnaks for your help!