Articles on: Transforms

Insert running total column

The Insert running total column step calculates the running total sum of any column you choose.

Insert running total column




Input/output



The input data we'll connect to this step is a list of Product orders.






The step will give us output data with a new column called "Running Total" that sums the "Quantity Sold" column as it moves down the rows.






Settings



Pick the dataset, then Type the "New column name" then type the "Target column" where the calculation will be based on it. After running the process your table now has a column placed right in a table, and It will display per row the running total of all values up to that row.

Updated on: 20/09/2022

Was this article helpful?

Share your feedback

Cancel

Thank you!