Running Total tool icon

Running Total Tool

Last modified: September 09, 2021

Docs are available before the release of Designer Cloud so you can get a sneak peek. This content might change between now and the official release.

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 Cloud.

Use Running Total to calculate a cumulative sum on a numeric column for each row in a file.

ROW VALUE RunningTotal_VALUE
A 10 10
B 12 22
C 4 26

It can also create sums of groups of rows and calculate the cumulative sums of multiple columns at the row or group level.

ROW 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 Columns to Compute Running Total. New columns are added with a RunTot_ prefix to show running totals for each column selected in the Columns to Compute Running Total section.
  2. You can also select Columns to Group By (Optional).
Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.