Friends here is the tricky part of data, I want to sum of value for next ten minutes for each minute
Here is data
Date Value
05/06/2010 9.51 am 1
05/06/2010 9.52 am 0
05/06/2010 9.53 am 1
05/06/2010 9.54 am 1
05/06/2010 9.55 am 0
05/06/2010 9.56 am 1
05/06/2010 9.57 am 0
05/06/2010 9.58 am 0
05/06/2010 9.59 am 1
05/06/2010 10 am 1
05/06/2010 10.01 am 1
05/06/2010 10.02 am 1
For
05/06/2010 9.51 am I want to show sum for next ten minutes that is from 05/06/2010 9.51 am to 05/06/2010 10.am i,e 6 and so on for each min
Date value
05/06/2010 9.51 am 6
05/06/2010 9.52 am 7
05/06/2010 9.53 am 8 so on, any help on this please?
Thanks in advance,
Vega
Here is data
Date Value
05/06/2010 9.51 am 1
05/06/2010 9.52 am 0
05/06/2010 9.53 am 1
05/06/2010 9.54 am 1
05/06/2010 9.55 am 0
05/06/2010 9.56 am 1
05/06/2010 9.57 am 0
05/06/2010 9.58 am 0
05/06/2010 9.59 am 1
05/06/2010 10 am 1
05/06/2010 10.01 am 1
05/06/2010 10.02 am 1
For
05/06/2010 9.51 am I want to show sum for next ten minutes that is from 05/06/2010 9.51 am to 05/06/2010 10.am i,e 6 and so on for each min
Date value
05/06/2010 9.51 am 6
05/06/2010 9.52 am 7
05/06/2010 9.53 am 8 so on, any help on this please?
Thanks in advance,
Vega