community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!
SOLVED

Rolling total of prior 3 rows including present row

Meteor

Hi All

 

For one of my use case i need to have 4 quarters sum.For any given row i need to have sum off 3 prior quarters or rows including present row.

 Below excel table will give more information about my usecase.

Any help is much appreciated. 

  

QuarterCommencements_TotalRunningTotal(4Rows)
Sep-840 
Dec-840 
Mar-850 
Sep-841067610676
Dec-84988520561
Mar-85841928980
Jun-851098739967
Sep-851070739998
Dec-85909339206
Mar-86807638863
Jun-86806135937
Sep-86917134401
Quasar

Hi @ramatp30

 

A Mulitle Row Formula tool could do the job well:

 

Capture1.PNG

Meteor

Yes i got it.

 

Thanks @jasperich :)

Labels