Alteryx - How to use Running Total or Cumulative Sum Tool

In this tutorial, we will learn "How to use Running Total or Cumulative Sum Tool" in Alteryx tool. Alteryx has many tools which comes in data transformation category includes tools that includes tools that summarize or rearrange data and one of them is The Running Total which enables you to create sums grouped by string fields.

The Running Total tool calculates a cumulative sum on a numeric field per record in a file. It can also create sums of groups of records and calculate the cumulative sums of multiple fields at the record or group level. This tool will easily sum up each consecutive row based on the field(s) selected.

Configuring the Running Total tool is very simple. There are two sections you will see in the Configuration window. The Group By section is optional. All of your fields will appear here. Selecting any fields here allows you to create sums of groups of records. We will see an example of this later on that will make more sense. The Create Running Total section is mandatory: you must select at least one of the checkboxes. Only numeric fields will appear as options. Any field you select here will have its rows summed.

To learn more, please follow us - http://www.sql-datatools.com To Learn more, please visit our YouTube channel at - http://www.youtube.com/c/Sql-datatools To Learn more, please visit our Instagram account at - https://www.instagram.com/asp.mukesh/ To Learn more, please visit our twitter account at - https://twitter.com/macxima To Learn more, please visit our Medium account at - https://medium.com/@macxima ... https://www.youtube.com/watch?v=Ymx0DPz9IIY