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