1 Reply Latest reply on Jul 18, 2018 10:02 AM by Ankit Bansal

    Calculate YoY growth

    Andrew Morgan

      Hi Tableau Community,

       

      In the attached workbook I want show YoY growth. Right now I am using a tableau calculation to do that. However, for the latest year I want to compare up to the same period last year not the full year . For example, in 2018 I have data from Aug 2017 to Jul 2018 wk-2 . So for this year I want calculate growth by comparing sales of Aug-2016  to Jul 2017 wk-2. The difficulty here is I don't have a proper date field but do I have week ID column (yyyymmwk) that identifies a week in the month.

       

      Any help is much appreciated.

       

      Thanks in advance.