Cumulative Sum in TABLE

[MK_QSL]

Hello Community Friends,

Need you help for below table.

I have first three columns…

• Week NO = Week Number
• Pallet Made = Pallet Prepared for customers in warehouse
• Pallet Dispatched = Pallet dispatched to respective customers

Need Last column “Pallet Remaining”

i.e.

Pallet Remaining for Week 1 = Pallet Made in Week 1 – Pallet Dispatched in Week 1

Pallet Remaining for Week 2 = Pallet Made in Week 2 – Pallet Dispatched in Week 2 + Pallet Remaining in Week 1

Pallet Remaining for Week 3 = Pallet Made in Week 3 – Pallet Dispatched in Week 3 + Pallet Remaining in Week 2

…. And so on….!!!

Thanks in advance.

Week NO	Pallet Made	Pallet Dispatched	Pallet Remaining
26	86	85	151
25	69	59	150
24	99	116	140
23	136	113	157
22	77	66	134
21	69	104	123
20	124	104	158
19	81	98	138
18	108	83	155
17	131	87	130
16	13	75	86
15	77	99	148
14	49	13	170
13	78	132	134
12	112	150	188
11	100	106	226
10	148	93	232
9	101	51	177
8	99	92	127
7	65	100	120
6	66	52	155
5	103	129	141
4	102	67	167
3	83	29	132
2	70	133	78
1	152	11	141

[#2]

Hi,

if in your case "Pallet made" is the 2 column in the table and "Pallet Dispatched" is column 3, then

add another expression in your table: Column(2)-Column(3).

[MK_QSL]

It should be something like.....

Pallet Made - Pallet Dispatched +Pallet Remaining in previous week...

[Gysbert_Wassenaar]

See attached example.

[MK_QSL]

Dear Gysbert,

Thanks for your reply.

Is there any way we can find the same solution in TABLE CHART rather than working in script.

Why I am asking is becuase the two columns Pallet Made and Pallet Dispatched are not available straight way.

These two columns are resulted as a part of some complex calculations and can't be used straight forward in script directly.