Running Total Tool
Running Total Tool
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.
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 |
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.