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 has 30 rows of order information showing the quantity sold, food type, customer username, and payment type per order.

After we connect this data to the step, it'll produce an output of 10 rows that sum quantities sold per food type in the "Quantity Sold" column.

Settings

Once connected to your flow, this step will auto-select a column to find the total amount per data group/category like quantity sold per food type. The result will display your grouped values and the total sum of them as a new table.

If you'd like to choose other columns for your sum calculation and which rows the calculation is grouped by, you can change the auto-selected ones by clicking into the blue boxes on the left-side toolbar.

You can also select multiple columns to sum and multiple rows to group by, or choose which columns to exclude.

Sum by Group

Input/output

Our input data has 30 rows of order information showing the quantity sold, food type, customer username, and payment type per order.

After we connect this data to the step, it'll produce an output of 10 rows that sum quantities sold per food type in the "Quantity Sold" column.

Settings

Once connected to your flow, this step will auto-select a column to find the total amount per data group/category like quantity sold per food type. The result will display your grouped values and the total sum of them as a new table.

If you'd like to choose other columns for your sum calculation and which rows the calculation is grouped by, you can change the auto-selected ones by clicking into the blue boxes on the left-side toolbar.

You can also select multiple columns to sum and multiple rows to group by, or choose which columns to exclude.

Updated on: 12 / 05 / 2022