3 Replies Latest reply on Nov 23, 2011 11:08 AM by Joe Mako

    Year over Year % Change for Running Weeks

    Santiago Restrepo

      I need to create a Year over Year % Change calculation for the  Running 4 Weeks (Last 4 Weeks)

      The last 4 Weeks include the newest/latest week with data, plus the previous 3 weeks (Week 39 to 42 of 2011 in this case), and the YoY % comparison is against Week 39 to 42 of 2010

       

      I have not been able to get the calculations/partitions to work appropriately in Tableau.

       

      Attached please find the Tableau packaged workbook with the data and my attempted calculations.

       

      The correct answers should be for    Product 1, Category 1, Brand 1, Kids, Week 42 of 2011:

      2010 Last 4 Weeks: 1,846,468

      2011 Last 4 Weeks: 1,642,499

      % Change: -11.05% (Tableau is calculating -6.56% erroneously)

       

       

      Thanks!!