Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Rolling total of prior 3 rows including present row

ramatp30
7 - Meteor
‎08-23-2018 10:28 PM

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
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

2 REPLIES 2
jasperlch
12 - Quasar
‎08-23-2018 10:37 PM

Hi @ramatp30, 

 

A Mulitle Row Formula tool could do the job well:

 

Capture1.PNG

New Workflow2.yxmd
Reply
0 Likes
ramatp30
7 - Meteor
‎08-23-2018 11:11 PM

Yes i got it.

 

Thanks @jasperich :)

Reply
0 Likes
GenAI Contest Form
Data Connection Manager
Labels
Top Solution Authors
View All