Running Total Tool
User Role
User Role* | Tool Access |
---|---|
Full User | ✓ |
Basic User | X |
*Applies to Alteryx One Professional and Enterprise Edition customers on Designer versions 2025.1+.
Use Running Total to calculate a cumulative sum on a numeric field per record in a file.
RECORD | VALUE | RunningTotal_VALUE |
---|---|---|
A | 10 | 10 |
B | 12 | 22 |
C | 4 | 26 |
It can also create sums of groups of records and calculate the cumulative sums of multiple fields at the record or group level.
Record | Group | VALUE_1 | RunTotal_VALUE_1 | VALUE_2 | RunTotal_VALUE_2 |
---|---|---|---|---|---|
A1 | A | 10 | 10 | 7 | 7 |
A2 | A | 5 | 15 | 3 | 10 |
B1 | B | 12 | 12 | 5 | 5 |
B2 | B | 8 | 20 | 1 | 6 |
C1 | C | 4 | 4 | 11 | 11 |
C2 | C | 2 | 6 | 9 | 20 |
D1 | D | 6 | 6 | 0 | 0 |
One Tool Example
Running Total has a One Tool Example. Visit Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer.
Configure the Tool
Select the fields to Group By (Optional).
Create Running Total: Select the numeric fields to create a running total. New columns are added with a RunTot_ prefix to show running totals for each column selected in the Create Running Total section.