3 Replies Latest reply on Apr 3, 2018 9:50 AM by Jim Dehner

    Week 1 of the year

    Tracey Linderman

      How do I get my week one to reflect the first full week of the year? With my week starting on Tuesday.

      WK 52 would have been 12/26/17 to 1/1/2018 and WK1 1/2/18 to 1/8/18

        • 1. Re: Week 1 of the year
          Ritesh Bisht

          Do you mean like this ?

          Screen Shot 2018-04-03 at 9.49.22 PM.png


          STEP 1




          Screen Shot 2018-04-03 at 9.51.59 PM.png





          Screen Shot 2018-04-03 at 9.49.37 PM.png



          STEP 2


          Screen Shot 2018-04-03 at 9.50.05 PM.png




          Order Date-->Column

          Datename -->Rows




          Both the FIXED calculations to Text


          STEP 3


          Filter on Datename as Tuesday


          Screen Shot 2018-04-03 at 9.54.00 PM.png




          If this post assists you to get to the solution then please mark it as HELPFUL and if it is the Solution that you are looking for then please mark it as CORRECT  so that it can help others as well.




          • 2. Re: Week 1 of the year
            Tracey Linderman

            Here is an image what my problem looks like. I need the first row to reflect the date range 12/26/17 to 1/1/18 and the second row to be 2018 W1 date range 1/2/18 to 1/8/18.


            • 3. Re: Week 1 of the year
              Jim Dehner

              Hi Tracey


              Have you tried using this calculated field for your date





              If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

              1 of 1 people found this helpful