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

[Anonymous]

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

[Anonymous]

hi,

i need some claification,how you bucket days you want to take as one week,can you please give me some equiement claification.

Regards

[Anonymous]

The field date is a just showing sunday of every week (i.e just one week )

for given (date) there many  report dates ..now  we need to map it in way that date should only have report date of that week range and do sum(gallon)

let me know if i'm not clear on this

[Anonymous]

i'm i clear on this ??

Any suggestion would be helpful