Orange polygon containing a stick figure running.

Running Total Tool

Last modified: December 24, 2020

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.

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_1 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

  1. Select the fields to Group By (Optional).
  2. 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.
Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.