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
Hi Koushik Neelakantha,
I understand your problem.
Did you take a look at these articles from our knowledge base?
Calculating a Compounded Annual Growth Rate | Tableau Software
Filtering Out Null Values in YoY Growth Calculations | Tableau Software
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...