Running totals for definite time frame

[Shrabasti]

Hi All,

I want to do a conditional running total column where every row will sum up the last 3 rows including itself.

Please see below example. Request for urgent help.

BU	Date	Values	Running Totals of last 3 months
ABC	Jan'21	0	0
ABC	Feb'21	1	1
ABC	Mar'21	1	2
ABC	April'21	1	3
ABC	May'21	0	2
XYZ	Jan'21	1	1
XYZ	Feb'21	3	4
XYZ	Mar'21	0	3
XYZ	April'21	1	1
XYZ	May'21	0	1
OPD	Jan'21	4	4
OPD	Feb'21	0	4
OPD	Mar'21	3	7
OPD	April'21	1	4
OPD	May'21	0	4

[TheOC · Accepted solution]

hey @Shrabasti 

I believe i have produced this for you:

Technically can be done all in one tool (the multi-row formula), however it ends up re-ordering the results - so i applied a record id before and after, and then dropped that in a select tool:
 

Also - FYI - if you have any Designer based questions, i would recommend popping them into the 'Designer Discussions' part of the community (https://community.alteryx.com/t5/Alteryx-Designer-Discussions/bd-p/designer-discussions) rather than General. General gets much less traction, and it will take longer to get your question answered.

Hope this helps
TheOC