10 Replies Latest reply: Nov 3, 2012 9:55 AM by Hyunku Cho RSS

    Chart using week as Dimension and shows current and previous week's data

      Hi I am trying to find out if this is possible. 

       

      WeekStart
      Count1
      Previous Week
      Count2

      1/1/2012

      10

      12/25/20113
      1/8/2012151/1/201210
      1/15/2012211/8/201215
      1/22/201251/15/201221
      1/29/201231/22/20125
      2/5/2012111/29/20123

       

      I have tried as following

      Dimension: WeekStart

       

      Count1 :

      =sum(Count)

       

      Previous Week:

      =WeekStart(WeekStart, -1, -1)

       

      Count2:

      =sum({$<WeekStart={$(=WeekStart(WeekStart, -1, -1))}>} Count) // -> not working as is

       

      Do you know if above table is possible?

       

      Thanks,

       

      Sean