Insert running total column
The Insert running total column step calculates the running total sum of any column you choose.
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.
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.
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
Thank you!