Articles on: Transforms

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.

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

Was this article helpful?

Share your feedback

Cancel

Thank you!