1 Reply Latest reply on Mar 14, 2013 5:21 AM by Brad Llewellyn

    Rolling calculations based on time.

    Monika G

      Hello,

       

      I have data which is refreshed on Weekly basis and level of data is at Week Ending date level. I would like to do a calculation as, last 6 weeks of data with respect to current week.

      For EX:

      Today's date: 03/14/2013

      Week start date: 03/10/2012

      I would like to calculate last 6 weeks of data for Week start date:03/10/2012.

       

      Can anyone please help on this calculation.

       

      Thanks,

      Monika.