4 Replies Latest reply on Nov 2, 2012 8:01 AM by C Palo

    Last N weeks YOY Aggregates

    C Palo

      Hello everyone,

       

      I am struggling with this workbook. All my data is weekly and I need to create aggregates os Latest 52 weeks, Latest 24 weeks, Latest 12 weeks, etc for the end user to chose from. I not only need these aggregates but also be able to calculate %chg vs previous 52 wks or whatever the period is. I am attaching a sample workbook for your reference. I have been able to create the YTD table and chart and need to be able to reproduce these tabs with the L52w or LNw mentioned above.

       

      Thanks for your help!

       

      Cristina