Calculate Compounding Amount of People/ Email Sends

[kpontarollo]

Hi All,

I am looking to see if there is a way to build the following into alteryx, like I did in excel. Column E & F are the sum of the cell above it and the cell to the left of it. For example, E5 = E4 + D5. I added a screen shot of my excel sheet as well.

[DataNath · Accepted solution]

Hey @kpontarollo, there is a Running Total tool in Alteryx. To mimic column E you would just bring that in and choose [Total] as your column to sum. Likewise for re-creating field F, you would bring on another running total tool and select the field that was created in the previous one to sum.

[Felipe_Ribeir0 · Accepted solution]

Hi @kpontarollo 

You can use the Multi-Row formula tool in a way very similar to the way that you are using excel for this:

[ShankerV · Accepted solution]

Hi @kpontarollo 

One way of doing this to reach the solution, 

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @kpontarollo 

Step 1:

Step 2:

Step 3;

Many thanks

Shanker V