2 Replies Latest reply on Jul 20, 2016 7:49 AM by Fabio Garcia

    Comparing Weeks

    Fabio Garcia

      Good morning people!

      I need to compare the value of sales in 2015 and 2016 per week, but the comparison have to start on the first Monday of the year (in 2015 on 05/01 and 2016 on 04/01), because the day of the week has particularities in the business of my company.

       

      In my attempt, the week begins on 01/01 in both years, which distorts the analysis

       

      Do you know how I can determine when to begin my "Week 1", depending on the year?

       

       

       

      Week.jpg