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.

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.