6 Replies Latest reply on Jan 5, 2016 2:14 PM by Norbert Maijoor

    How to compare current week's data to last year's same time period

    Katrina Roque

      Hello,

       

      I am currently trying to find the best way to calculate this week's data and compare the values to the same period but using last year's data. I would like to get both on the same axis similar to the attached picture titled "sample chart." 

       

      I have also attached a sample workbook on what I was trying to achieve.  Any insight is greatly appreciated. =)

       

      -Katrina