Compute grouped summaries
Finance doesn't want a row per line item — they want rollups by category, similar to a pivot table once the data is flat.
Import the pre-split items and add a Summarize node to compute average price and total quantity, grouped by category.
This exercise is part of the course
Intermediate Workflow Automation with n8n
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise