Compute grouped summaries
Acme Retail's finance team wants category-level totals — not thirteen individual line items. The data is already split and flat, so you just need to roll it up the way a spreadsheet pivot table would.
You'll import pre-split line items and add a Summarize node to compute the sum of price and qty, grouped by category, so thirteen rows collapse to four category totals.
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