Running totals for definite time frame

Question

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.

BUDateValuesRunning Totals of last 3 monthsABCJan'2100ABCFeb'2111ABCMar'2112ABCApril'2113ABCMay'2102XYZJan'2111XYZFeb'2134XYZMar'2103XYZApril'2111XYZMay'2101OPDJan'2144OPDFeb'2104OPDMar'2137OPDApril'2114OPDMay'2104

TheOC · Accepted Answer

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