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

    Growth % Calculation




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


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




      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