**Pivot Tables summarise your data by grouping rows into categories and computing aggregations across them, so you can spot patterns without writing formulas.**

![Building a Pivot Table](/images/pivot.gif)

## Create a Pivot Table

1. **Open** the Sheet you want to analyse.
2. **Click** **Pivot** in the toolbar, or press `Cmd/Ctrl + Shift + P`.
3. **Choose** the source Sheet if prompted.
4. **Configure** the Pivot Table:
   - **Group by**: the categories to break results down by, for example `country` or `product`.
   - **Aggregations**: the numbers to compute, for example `sum(revenue)`, `count(*)`, or `avg(order_value)`.
5. **Click** **Done**.

The result opens as a **new tab** that you can keep exploring, chart, or add to a Dashboard.

## What you can do next

- **Turn a Pivot Table into a Chart**: see [Creating Visualizations](/docs/creating-visualizations), so you can visualise the summary.
- **Add it to a Dashboard**: see [Building Dashboards](/docs/building-dashboards), so you can share it as part of a report.
- **Narrow the input first with filters**: see [Filtering Data](/docs/filtering-data), so the Pivot Table only reflects the rows you care about.

## Notes

- Pivot results open as a new tab and stay linked to the source Sheet.
- Numeric aggregations (sum, avg, and so on) require numeric columns.

## Video walkthrough

[Watch the Filters, Pivot and Stats feature video](https://youtu.be/KwbNxPK9JNI#embed)

## Related pages

- [Filtering Data](/docs/filtering-data)
- [Creating Visualizations](/docs/creating-visualizations)
- [Building Dashboards](/docs/building-dashboards)
- [Joining Data](/docs/joining-data)