2 Replies Latest reply on Sep 28, 2012 6:21 AM by C Palo

    Latest 52 weeks - Aggregate of weekly data

    C Palo

      Folks I need some help with a workbook...

       

      How do I calculate Latest 52 weeks, Latest 24 weeks and so forth? Also how to get vs YAG?

       

      Thanks,

       

      Cristina

        • 1. Re: Latest 52 weeks - Aggregate of weekly data
          Tracy Rodgers

          Hi Cristina,

           

          To get the last 52, 24, etc weeks relative today, a calculated field similar to the following can be created:

           

          if [Order Date]>=DATEADD('week', -52, today())  and [Order Date]<=today() then 'show' else 'hide' end

           

          Depending what the number that is placed in the Dateadd section of the calculation will determine the number of weeks.

           

          Then, place this on the filter and select 'show.'

           

          Hope this helps!

           

          -Tracy

          • 2. Re: Latest 52 weeks - Aggregate of weekly data
            C Palo

            Tracy,

             

            Another challenge came up...what if I want to see on the same table Latest 52 wks, Latest 24 wks and Latest 4 wks for example....so filtering on 1 rolling period does not help...I have attached a workbook and the table I am looking for should be something like below:

                                2011  2012   2011   2012 2011   2012

                                L52w L52w   L24w  L24w  L4w   L4w

            PROD A

            PROD B

            PROD C

             

             

            Thank again for your help!