Sum by Group
The Sum by group step calculates the sum of all values in one or more columns. This functionality is similar to the SUMIF function in Excel.
Our input data is a list of sales orders.
After we connect this data to the step, it'll produce an output of that sum the "Sales Amount" and "Tax Amt" columns for for each "Product Name".
Pick the dataset, then type in "Sum columns(s)" the columns names to calculate their sum. Multiple columns separated by comma,
then, type in "Group by columns(s)" the columns names to create a new row for each unique value in columns. Multiple columns separated by comma.
Sum by Group
Input/output
Our input data is a list of sales orders.
After we connect this data to the step, it'll produce an output of that sum the "Sales Amount" and "Tax Amt" columns for for each "Product Name".
Settings
Pick the dataset, then type in "Sum columns(s)" the columns names to calculate their sum. Multiple columns separated by comma,
then, type in "Group by columns(s)" the columns names to create a new row for each unique value in columns. Multiple columns separated by comma.
Updated on: 20/09/2022
Thank you!