Running total on multiple columns using set number of rows

[rce]

Hey community!

I've tried searching for an answer to this but can't seem to connect the dots (so I apologize if this is relatively simple).

Essentially what I have is a table that contains daily sales figures for several categories. The date is the rows while the categories are across the top as column headers. I need to add new columns for each category that adds a running total for the previous 35 days (so the 36th record would be the first entry, and it would populate all the way down). I've added a sample table below.

date	cat A	cat B	cat C	running total - A	running total - B	running total - C
1/1/2019	4	5	10
1/2/2019	3	7	1
1/3/2019	1	6	6
1/4/2019	5	6	6
1/5/2019	10	2	3
1/6/2019	8	6	10
1/7/2019	3	1	4
1/8/2019	1	7	2
1/9/2019	5	7	6
1/10/2019	9	3	9
1/11/2019	10	3	7
1/12/2019	0	10	7
1/13/2019	2	3	6
1/14/2019	4	6	9
1/15/2019	2	8	4
1/16/2019	2	8	3
1/17/2019	1	7	8
1/18/2019	9	9	0
1/19/2019	1	6	3
1/20/2019	0	3	3
1/21/2019	1	7	10
1/22/2019	10	7	8
1/23/2019	4	1	0
1/24/2019	2	5	10
1/25/2019	7	8	6
1/26/2019	2	10	3
1/27/2019	1	4	3
1/28/2019	9	0	10
1/29/2019	9	6	10
1/30/2019	5	2	8
1/31/2019	9	9	3
2/1/2019	10	3	5
2/2/2019	5	3	8
2/3/2019	7	0	0
2/4/2019	7	6	3	161	178	191
2/5/2019	3	7	4	164	179	184
2/6/2019	2	9	6	164	179	187
2/7/2019	10	4	1	165	182	187
2/8/2019	7	9	10	170	180	182
2/9/2019	8	7	3	167	187	189
2/10/2019	10	2	3	167	188	182
2/11/2019	6	8	10	174	189	181
2/12/2019	0	8	4	179	190	189
2/13/2019	10	9	8	174	191	187
2/14/2019	7	4	9	175	197	186
2/15/2019	2	1	3	172	198	188
2/16/2019	1	10	1	174	189	184
2/17/2019	4	2	4	173	196	179
2/18/2019	4	9	5	173	192	174
2/19/2019	6	1	6	175	193	175
2/20/2019	0	8	6	179	186	178
2/21/2019	1	2	8	178	187	176
2/22/2019	0	10	8	170	180	184
2/23/2019	5	5	4	169	184	189
2/24/2019	1	9	10	174	186	190
2/25/2019	10	7	6	174	188	190
2/26/2019	4	4	0	174	188	188
2/27/2019	3	10	1	174	191	188
2/28/2019	5	9	1	175	196	179

[BrandonB]

I did this with a few multi row formulas. This gets the job done, but I am curious if anyone else has a more elegant solution. See workflow that is attached!

 

[benakesh]

Hi @rce ,

I tried with iterative macro . If it helps  please mark this as a  solution .

[Jonathan-Sherman · Accepted solution]

Hi @rce,

I've built on @BrandonB and believe it's a more dynamic approach as it will automatically take into account and create running totals for any new columns added.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[rce]

That's perfect Jonathan, thank you.