Cumulative data

[#1]

Is there anyone how can help me with this issue?

I have the following camulative data:

Year     Month     Fact

2011     1               100

2011     2               150

2011     3               300

2012     1               80

2012     2               120

2012     3               200

For each year I want to calculate in my script the difference between the month's.

So the following data is what I need:

Year     Month     Fact

2011     1               100

2011     2               50

2011     3               150

2012     1               80

2012     2               40

2012     3               80

What script/function must I use to get the data between the month's for each year separate?

[jonathandienst]

Hi

Something like this:

LOAD Year,

          Month

          Amount

          Amount - Alt(Previous(Amount), 0) As Difference,

          ...

FROM SourceTable

ORDER By Year, Month

Regards

Jonathan