Hello Everyone , I have This DataSet :   Users Spendings_M1 Spendings_M2   Spendings_M3   12353 30 100   10   12353 10 200   20   12353 20 300   30   12353 40 400   40   12353 30 500   50   14562 10 300   70   14562 20 400   80   14562 50 500   90   14562 60 600   100   14562 70 700   110     And What I Want To Do , is to make an iterative sum for each user  ,i.e:  like for user_1 i want , for the first line , the first spending , for the second column , i want , to sum of spending between line 1 and line 2 , for the third column , i want the sum of spending in line1 , line2 , line 3 .....ect , like my output would look like this :   Users Spendings_M1 Spendings_M2   Spendings_M3   TOT_SPEN_M1 TOT_SPEN_M2 TOT_SPEN_M3 12353 30 100   10   30 100 10   12353 10 200   20   40 300 30   12353 20 300   30   60 600 60   12353 40 400   40   100 1000 100   12353 30 500   50   130 1500 150   14562 10 300   70   10 300 70   14562 20 400   80   30 700 150   14562 50 500   90   80 1200 240   14562 60 600   100   140 1800 340   14562 70 700   110   210 2500 440     Any suggestions on how to do that , would be much appreciated , thank you. ... View more

Hello Everyone , I have this Dataset: regions cities Dates 1 FGG 25/01/1998 1 HGT 26/01/1998 1 HJK 27/01/1998 2 LOI . 2 DCF 25/01/2001 2 VG 26/01/2001 2 BBVB 28/01/2001 3 DFR 11/07/2005 3 ZAS 12/07/2005   And What I want to do is , to take the mean of the Dates , when I have multiple Dates for the same region , like my output would be something like this :   regions cities Dates 1 FGG 26/01/1998 1 HGT 26/01/1998 1 HJK 26/01/1998 2 LOI 26/01/2001 2 DCF 26/01/2001 2 VG 26/01/2001 2 BBVB 26/01/2001 3 DFR 11/07/2005 3 ZAS 11/07/2005 3 EWS 16/02/2010 3 WE 16/11/2010     Any Suggestion On how to do that would be much appreciated , thank you.   ... View more

Hello Everyone , I have this DataSet :   regions cities Dates ML FGG 25/01/1998 ML HGT 25/02/2000 ML HJK 15/06/1999 ML LOI 02/05/2003 RS DCF 14/06/2000 RS VG 03/04/1992 RS BBVB 03/10/2003 RS DFR 11/07/2005 GT ZAS 03/08/2006 GT EWS 16/02/2010 GT WE 17/11/2011   & What i want to do , is to assign an incremental number indexing to a the key column , like my output would be like this :   regions cities Dates 1 FGG 25/01/1998 1 HGT 25/02/2000 1 HJK 15/06/1999 1 LOI 02/05/2003 2 DCF 14/06/2000 2 VG 03/04/1992 2 BBVB 03/10/2003 2 DFR 11/07/2005 3 ZAS 03/08/2006 3 EWS 16/02/2010 3 WE 17/11/2011   Any Idea , how i could eventually do that ? , any suggestion  would be much appreciated , thank you. ... View more

Hello Everyone , I have This DataSet :    User   SPENDING User_1    50,32$ User_1   250,36$ User_1   322,2$ User_1   222,2$ User_2    30,2$ User_2    563$ User_2   24,23$ User_2   210,32$   And What I Want To Do , is to make an iterative sum for each user  ,i.e:  like for user_1 i want , for the first line , the first spending , for the second column , i want , to sum of spending between line 1 and line 2 , for the third column , i want the sum of spending in line1 , line2 , line 3 .....ect , like my output would look like this :    User   SPENDING Total User_1    50,32$ 50,32$ User_1 250,36$ 300,68$ User_1 322,2$ 622,88$ User_1 222,2$ 845,08$ User_2 30,2$ 30,2$ User_2 563$ 593,2$ User_2 24,23$ 617,43$ User_2 210,32$ 827,75$   Any suggestions on how to do that , would be much appreciated , thank you. ... View more