The Pivot Table Google Sheets Tutorial

To create a pivot table from the above data, follow the steps shown below:

• Select all the data in your spreadsheet (on which you want to base your pivot table).
• From the Insert menu, select Pivot table.

• In the ‘Create pivot table’ box, if you want to display your pivot table in a new sheet, then select the radio button next to ‘New sheet’. If you want it in the same sheet, select the radio button next to ‘Existing sheet’.

• You should now see a pivot table created. If you had asked for the table to be displayed in a new sheet, you should find the new tab name as ‘Pivot Table 1’.  You can rename it to something else if you want to.

At the beginning, your pivot table would be blank as shown in the image below. It will start filling up once you start adding rows, columns and values to the table (explained in step 6).

1. The range of cells on which the pivot table is based
2. Some suggestions for pivot tables based on your data
3. Options to customize your pivot table according to your requirement. This includes 4 insert options:
   1. Rows
   2. Columns
   3. Values
   4. Filters

Suggested Pivot Tables

Google Sheets provides a few ideas for pivot tables based on your selected data. For example, for our sample data, Google Sheets suggests the following:

• Average of Unit Price for each Region
• Count of Country for each Region
• Number of unique Item Type for each Region

Clicking any of these suggestions will automatically create your initial pivot table. For example, let’s click on the second suggestion: “Count of Country for each Region”:

Looking at the above table lets us know at a glance how many countries operate from each geographical region.