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