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

    Last N weeks YOY Aggregates

    Cristina 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!