1 Reply Latest reply on Aug 25, 2016 6:41 AM by lenaic.ridinger

    Growth % Calculation

    koushik.neelakantha

      Hello,

       

      Please find the excel sheet. I need to calculate Growth %= CY-PY/CY

       

      In the excel sheet, I have 3 columns. Year,Sales,Month.

       

      Year-2016,2015,2014.

       

      I need to create a year parameter. If I select 2016, As sales are present till May, I need to get Growth % as (CY-PY Till current year month( CY sales are till May))/PY till CY Month

       

      If I select 2015, My CY will be 2015 and PY will be 2014 & Growth should be calculated as per the logic.

       

      If I select 2014, as 2013 is not available I need to get 100%

       

      Please help me out in this aspect. I need to get the calculation without hardcoding.

      Tableau Desktop: 9.0

       

      Regards,

       

      Koushik.