> For the complete documentation index, see [llms.txt](https://doc.duaer.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://doc.duaer.com/snippets/group-and-sum.md).

# Group, sum, and count items in Duaer (like a pivot table)

In Duaer, the Summarize node groups items by region, customer, or category and returns sums, counts, and averages without code.
## Group and total in Duaer

1. Add [Summarize](/build/summarize.md).
2. Under Fields to Summarize add an entry with Aggregation Sum and Field amount. Add more as needed, such as Count of order_id or Average of amount.
3. Set Fields to Split By to the group field, such as region; separate several with commas.
4. Select Execute step. You get one item per group, with the total in sum_amount and counts in fields like count_order_id.

Aggregations: Append, Average, Concatenate, Count, Count Unique, Max, Min, Sum. Add [Sort](/build/sort.md) to rank by total and Convert to File to export.

## When the sum is wrong

Amounts stored as text such as "1,280.50" do not sum. Convert them in Edit Fields first: {{ Number(String($json.amount).replace(/,/g, "")) }}, type Number.

## Duaer online tools

- [Split an Excel table by column online (one sheet per value)](https://doc.duaer.com/tools/split-table-by-column.md)
## Questions

### Can Duaer summarize like an Excel pivot table?

Yes. The Duaer Summarize node groups by Fields to Split By and computes sum, count, average, and more under Fields to Summarize.

### What is the total field called in Duaer Summarize?

Duaer names it aggregation_field, such as sum_amount or count_order_id.

## Related

- [Summarize fields in Duaer](https://doc.duaer.com/build/summarize.md)
- [Sort items in Duaer](https://doc.duaer.com/build/sort.md)
- [Categorize bank statement lines and total them by category with Duaer](https://doc.duaer.com/tasks/categorize-bank-statements.md)
- [Split an array into separate items in Duaer](https://doc.duaer.com/snippets/split-array-into-items.md)