3 Replies Latest reply: Feb 18, 2013 2:41 PM by Raj Vadde RSS

    Need to do Aggregation at script level over a range of date for all weeks

    Raj Vadde

      Hi All,

               This might be a simple but i'm not sure how to do this ??

       

      i want to aggregate values for each week and only for certain range of dates (within that week )......

       

      say suppose my date is  (1/27/2013) it should sum (gallon) for report date ranging from (1/21/2013 - 1/27/2013)

       

      need this in script (backend) ???

       

      here my data in excel and my application ...

       

      let me know if i'm not clear?

       

      and please give your valuable suggestion