Hi all, I have a programming question regarding the calculation of a rolling sum for a range of variables. To simplify the question I have only included two variables to be calculated. The sum must be calculated for each customer represented in the data. DATA = work.ydelser PERSON ID DATE TOTAL PROD_A ... A 08-01-2014 10 ... A 13-01-2014 12 ... A 23-01-2014 11 A 12-02-2014 17 B 07-01-2014 26 B 17-01-2014 50 B 25-02-2014 10 B 03-03-2014 10 The result I would like to have is: DATA = work.ydel_sum PERSON ID DATE TOTALsum PROD_A A 08-01-2014 10 ... A 13-01-2014 22 A 23-01-2014 33 A 12-02-2014 22 B 07-01-2014 26 B 17-01-2014 76 B 25-02-2014 10 B 03-03-2014 20 The computed dataset does not have to include the original variable. The date is in "date format". I will use the code in a code-program in Enterprise Guide, but if anyone knows how to solve the question by Enterprise functions, please let me know. I have seen a privious topic on this matter, but I cannot figure out how to use the "cards" function. Thanks in advance!
... View more