TAKE A BREAK

Want to know how to make a pivot table in Google Sheets? The short answer: select your data, go to Insert > Pivot table, and choose where the summary should go. Then drag fields into Rows, Columns, and Values to group and add up your numbers. Google's help page on creating and using pivot tables describes the same menu path.
The menu path is the easy part. What matters is knowing what each setting changes in the output. Below, we build a small sales summary, explain every option we use, and cover grouping by month, filtering, and the problems people hit most often.
A pivot table reads one block of data, so your source sheet needs a clean structure:
We will use this small table, where each row is one sale:
| Region | Salesperson | Product | Order Date | Units Sold |
|---|---|---|---|---|
| North | Ana | Notebook | 1/5/2026 | 12 |
| North | Ben | Desk Lamp | 1/9/2026 | 4 |
| South | Carla | Notebook | 2/2/2026 | 20 |
| South | Diego | Chair | 2/14/2026 | 3 |
| West | Eva | Desk Lamp | 3/3/2026 | 7 |
| West | Felix | Chair | 3/21/2026 | 5 |
The goal is simple: see how many units each region sold, which products drive those numbers, and how sales move from month to month.
A pivot table editor opens on the right. It has four sections: Rows, Columns, Values, and Filters. Each one controls a different part of the output.
Each section does one specific job:
You never type the labels yourself. Sheets reads the unique values from the field you pick. If Region contains North, South, and West, you get three row labels automatically.
Try it with Region in Rows and Units Sold in Values. The result looks like this:
| Region | Sum of Units Sold |
|---|---|
| North | 16 |
| South | 23 |
| West | 12 |
| Grand total | 51 |
Notice that Sheets added the numbers for you. Each region's total is the sum of its rows in the source data.
For numeric fields, Sheets sums values by default. You can change that in the Values section with the Summarize by setting. The options that matter most are:
The other settings change how results are arranged and displayed:
| Setting | What it changes | When to use it |
|---|---|---|
| Summarize by | How values combine (SUM, COUNTA, AVERAGE) | Totals versus counts |
| Show as | Raw numbers versus a percentage of a row or column total | Market share within a region |
| Order and Sort by | The order of rows or columns, by name or by value | Putting the biggest region first |
| Show totals | Adds row and column totals | A quick grand total |
For example, set Sort by to Sum of Units Sold in descending order, and North moves to the top because it has the highest total among the three regions. Google's guide to customizing a pivot table covers these sorting and totals options in more detail.
Monthly totals are one of the most common reasons to build a pivot table. Here is how to group dates:
Sheets now rolls every sale into its month, so January, February, and March appear as separate rows. This only works when the dates are stored as real dates. If the grouping option is missing, check the source column first. If you also track monthly spending, our monthly budget guide uses a similar month-by-month setup.
For manual groups, right-click the row labels you want to combine, such as North and West, and choose Create pivot group. Sheets creates a new group label you can rename.
Sheets does not offer a week option in the date group menu. You need a helper column in your source data. In a new column next to Order Date, use this formula in the first data row, where A2 holds the date:
=A2-WEEKDAY(A2,2)+1
This returns the Monday of the week that contains that date. Format the column as a date, then include it in your source range before you create the pivot table, or widen the range afterward. You can then add the helper column to Rows and sum Units Sold by week.
The Filters section gives you two ways to narrow the results:
Use a condition when the rule matters more than the specific items, such as all products with the word Desk in their name. Use a value filter when you want to pick particular items by hand.
For example, filter Product by condition with contains Desk. The table now shows only Desk Lamp sales:
| Region | Sum of Units Sold (Desk Lamp only) |
|---|---|
| North | 4 |
| West | 7 |
| Grand total | 11 |
Filter settings are saved with the pivot table. Google's customization guide explains how filter settings work in more detail.
Sheets sometimes defaults to COUNTA when a column mixes data types, such as numbers and text in the same field. Sheets Bootcamp's pivot table guide describes this behavior. To fix it, clean the column so it holds only numbers, then set Summarize by to SUM in the Values section.
A pivot table only reads rows inside its original source range. If you add rows below the range, they will not show up. Insert new rows inside the existing block, or update the source range so it covers the new data. A blank row in the middle of the data has the same effect, because the pivot stops reading there.
Click any cell inside the pivot table. The editor should reopen on the right side of the screen.
In current versions of Sheets, pivot tables recalculate when the source data changes, so you usually do not need a manual refresh. OWOX's complete guide to pivot tables covers how the table stays linked to your data.
Yes. Place each pivot table in a separate area that does not overlap with the other. Each one needs its own source range, and both can point to the same data.
Not directly. A pivot table reads one source range. Combine the data first with a formula such as QUERY or an array formula that stacks the sheets, then build the pivot table from the combined result.
Yes. Select the pivot table output, then go to Insert > Chart. Sheets does not have a separate pivot chart type. The chart uses the pivot output as its data range, so it reflects the summary you built, as OWOX explains in its pivot chart guide.
No. The pivot table is only a summary. Your source data stays on its original sheet. To remove the summary, select the pivot table cells and clear them.
To make a pivot table in Google Sheets, clean your data, go to Insert > Pivot table, and then build the summary with Rows, Columns, and Values. Use Summarize by to choose how numbers combine, Sort and Show totals to shape the layout, and Filters to narrow the results. Once you know what each setting does, you can turn a long list of sales rows into a summary you can read in seconds.