The Alteryx running total tool helps you return or find a numeric column’s running total with the given source. To demonstrate this running total tool, we used the below CSV file.
First, drag and drop the Input Data Tool, and select the Customers CSV file from the Connect a File or Database option configuration tab.
Alteryx Running Total Example
Please go to the transform tab and drag-and-drop the Running total tool to the canvas. Next, connect the Input to this.
If you observe the Create Running Total section under the Configuration tab, it says that No numeric fields available. As we said earlier, we need a numeric column to perform the Running total.
To change the data type of the columns, we added Select tool in between input and running total tools. Next, we change the EmpID to int, yearly Income to integer and renamed it as Income, and sales column to double.
Now you can see those three numeric columns under the create running total section of the Alteryx.
Let me calculate the running total of the Income. To do this, please checkmark the income column and hit the Run button. From the below screenshot, you can see the result.
This time we were calculating the running total of both the sales and Income.
We haven’t used the Group By option, which is optional under the Alteryx Running total Configuration tab. By using this option, we can calculate the running total for each Group. Let me checkmark the Education column. It means it will calculate the running total of Income and Sales for each Education group.
This time, we are using get Education and Occupation as the Group by columns. It will group the records based on Education and occupation. Then, it will find the running total of that Group.