"moving Range"

[sedgely]

Hi all
Don't know if this is possible but here goes...

i have a view that returns data like:

DATE AREA No1 No2 FINAL
01/04/06 firstArea 20 28 .71
02/04/06 firstArea 15 22 .68
.
.
.
01/04/06 secondArea 14 20 .70
01/04/06 secondArea 27 32 .84
.
.
.

what i want to be able to do is create another view that returns the same as above BUT with an extra column with the difference between the previous days "FINAL" Figure and the given days FINAL figure e.g.

DATE AREA No1 No2 FINAL MOVING
01/04/06 firstArea 20 28 .71 -
02/04/06 firstArea 15 22 .68 .3
02/04/06 firstArea 14 20 .70 .02
01/04/06 secondArea 14 20 .70 0
01/04/06 secondArea 27 32 .84 .14
.
.
.


Cheers, Craig
Si fractum non sit, noli id reficere

 

[Andel]

do you have a unique key included in the first view? if so, you should be able to calculate the 'moving' column in a new view.