New to Qlik Sense

[vmoreno2605]

Hi Qlik Masters! 

I need your help!

Here is the situation: 

Here, i have this data

Store	Customer	Receipt_Date	Money in suspense
1	10	42589	50
1	10	42895	-50
1	10	43005	23
1	10	43035	69
1	11	41500	65
1	11	41550	-95
1	11	41555	58
1	11	41623	-450
1	11	41950	321
2	12	43589	65
2	12	43599	-65
2	12	43600	68
2	12	43612	65
2	12	43615	-265
2	12	43650	75
2	13	42950	-95
2	13	42990	5
2	13	43000	32
2	13	43101	-12
2	13	43125	5

And i want to create this column 'Cumulative'

Store	Customer	Receipt_Date	Money in suspense	Cumulative
1	10	42589	50	50
1	10	42895	-50	0
1	10	43005	23	23
1	10	43035	69	92
1	11	41500	65	65
1	11	41550	-95	-30
1	11	41555	58	28
1	11	41623	-450	-422
1	11	41950	321	-101
2	12	43589	65	65
2	12	43599	-65	0
2	12	43600	68	68
2	12	43612	65	133
2	12	43615	-265	-132
2	12	43650	75	-57
2	13	42950	-95	-95
2	13	42990	5	-90
2	13	43000	32	-58
2	13	43101	-12	-70
2	13	43125	5	-65

Any ideas? 

Thanks in advance

-D

[Ezir · Accepted solution]

Hi @vmoreno2605 ,

In load editor you can use RangeSum() and Peek(). 

TABLE:
LOAD Store, Customer, Receipt_Date, [Money in suspense], RangeSum(peek('Cumulative') , [Money in suspense]) AS Cumulative ...

Regards,

Ezir

[jmbenedetto]

Hello, Ezir.

Would you know if it is possible to make have the cumulative value dependent on another dimension?