rangesum movil sum

[dcd123456]

Hello

I have a table with timestamps and value. for example

stamp	Value
6:05:00	39,41
6:12:35	27,93
6:20:10	25,13
6:27:45	21,2
6:35:21	19,94
6:39:43	29,54
6:44:06	107,85
6:48:28	24,37
6:52:51	40,8
6:57:14	100,55
7:01:36	58,09
7:05:03	89,2
7:08:30	51,45
7:11:57	81,24
7:15:24	58,11
7:18:51	66,5
7:22:18	76,02
7:25:44	97,27
7:29:11	125,55
7:32:38	50,12
7:35:48	70,81
7:38:58	99,11

i need to create a new column, each value in the new colum must be the sum of the above values of the field Value but only of the revords where the stamp time is lower than 60 minutes of the first record.

For excample in the above table, the new value of the record 1 will be the sum of the above records  records where the stamp is lower than 6:05:00 + 60 minutes --> 7:05:00, and so it must sum the values from 39,41 (stamp = 39,41)  to 58,09 (stamp 7:01:36).

In the secord rows the same, the new value field must sum the values from 27,93 (stamp 6:12:35) to the value 81,24(stamp 7:11:57)

and so on....

stamp	Value	NewSum Value
6:05:00	39,41	494,81
6:12:35	27,93	677,29
6:20:10	25,13	773,97
6:27:45	21,2	….
6:35:21	19,94
6:39:43	29,54
6:44:06	107,85
6:48:28	24,37
6:52:51	40,8
6:57:14	100,55
7:01:36	58,09
7:05:03	89,2
7:08:30	51,45
7:11:57	81,24
7:15:24	58,11
7:18:51	66,5
7:22:18	76,02
7:25:44	97,27
7:29:11	125,55
7:32:38	50,12
7:35:48	70,81
7:38:58	99,11
7:42:08	140,6
7:45:17	164,24
7:48:27	59,69
7:51:37	80,4

is there a way to do this in the scrip or in a graph expresion using rangesum or other function

thanks in advance for your help

regards

[dcd123456]

Anyone know if there is a way to use rangesum with above function but filtering the records that above function must take, for example filtering by the value of other field.

Thanks in advance

regards

[jerryyang756]

Dimension : stamp

Expression:

     1) Sum(Value)

     2) If(stamp < '7:05:00', Rangesum(Above(Sum(Value),0,RowNo(TOTAL))))