View All Docs
Product overview
Account overview
Integrations
Transforms
Security
Hide Navigation
Product overview
Account overview
Integrations
Transforms
Security
Use case FAQs
Transforms →
Sum by group

Sum by group

🎁
$250 PRIZE
Enter the Custom Transform Contest
To celebrate this launch, we’re hosting a contest to highlight the creative ways our customers solve problems with this step. Show off your creativity for the chance to win $250 or Parabola swag! 

Click the link below to learn more and submit your entry. The contest closes on Friday, April 11 @ 5pm PST. 
Enter now

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.

Take a look at this Parabola University video to watch the Sum by group step at work.

Input/output

Our input data has 39 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 9 rows that sum quantities sold per food type in the "Quantity Sold" column.

Default 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.

Custom settings

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.

Contents