1
Select your data
Highlight the table, including its headers.
How to create a pivot table in Google Sheets
Summarize a table in seconds: insert a pivot table, then add the fields to group by and total.
Accounting & Finance
2
Click Insert
Open the Insert menu.
3
Click Pivot table
Choose Pivot table.
4
Click Create
Keep New sheet selected and click Create. The pivot table opens on its own sheet.
5
Click Add next to Rows
In the Pivot table editor, click Add next to Rows.
6
Click the field to group by
Choose the column to group by - here, Region.
7
Click Add next to Values
Click Add next to Values.
8
Click the field to total
Choose the column to add up - here, Sales. It is summed by default.
9
Pivot table created
The table shows total sales for each region. Add more rows or columns to break it down further.
Make this walkthrough your own
Duplicate this template, swap in your own screens, and share it with your team. Free to start — no credit card.