Create a Google Sheets PivotTable

Contents
  1. Get the right data from all these results
  2. When do you use a pivot table?
  3. PivotTable Scheduling
  4. PivotTable Areas
  5. Create a pivot table
  6. Edit or delete data

Get the right data from all these results

PivotTables are powerful spreadsheet functions that can summarize only the data that is important to your needs from a large data table. You can use interactive pivot tables to explore large amounts of data and extract only what you need. Here’s how to create a pivot table in Google Sheets.

When do you use a pivot table?

If you have a huge amount of data and only want to view a few data fields, a pivot table makes this process easier. You can summarize this data just as easily. You can create custom tables to find repeating patterns in your data so you can make accurate data predictions. In addition, you can efficiently create your own reports.

PivotTable Scheduling

Taking the time to plan ahead before creating a Google Sheets PivotTable will ensure the most efficient outcome.

  1. Check your source data to make sure it’s well organized. It cannot contain empty rows or columns. It should also have headings that contain all the necessary information for the pivot table.

  2. Format the data as a table by selecting the cells containing the data and clicking the button Filter on the toolbar. The cells in the first row are formatted as column headings.

  3. Specify what you want from the pivot table. Setting a goal for what you want to achieve will help you get it right.

  4. Think about how you want the results to be displayed. Knowing what data you want to display in specific columns and rows makes creating a pivot table even easier.

PivotTable Areas

All pivot tables have four separate areas. Each area has a specific purpose. Exploring these areas will help you plan and create a pivot table in Google Sheets.

  1. The Row area displays data in rows on the left side of the pivot table. This area is used for data that you want to classify and group, such as products, titles, or regions. This area cannot contain any fields.

  2. The column area contains the headings in the pivot table. The column area can help you spot trends over time.

  3. Google Sheets calculates and counts the data in the range. Typically, you’ll use this area for data you want to measure, such as sums, numbers, or averages.

  4. You can use the filter area to create filters. When you select a data field in the Filters area, the entire PivotTable is filtered based on that information.

Create a pivot table

Google Sheets can automatically create a pivot table with your data. It may propose one or more tables based on the data you provide. You can accept the offer to create a pivot table right away or create one manually.

  1. Open a spreadsheet in Google Sheets with the data you want to use.

  2. Select the table with the source data you want to use.

  3. Click Facts

  4. Click Turntable. A new sheet will open and the pivot table editor will open on the right side of the screen.

  5. Click one of the suggested pivot tables at the top of the pivot table editor to apply it to your data.

  6. Press the button To add next to each area and select the desired data field in that area if you want to manually create a pivot table.

  7. Click To add in the Filters pane, and if you choose, select the condition or value by which you want to filter the data.

  8. Click the arrow in the section to arrange or sort columns or rows Order or To sort in the PivotTable Editor pane and select the option you want to apply.

  9. Check box Show totals to display column or row totals.

Edit or delete data

You can change or delete the data displayed in the pivot table at any time.

  1. Open the worksheet with the pivot table.

  2. Click pivot table.

  3. Drag a field to another category in the pivot table editor to move it.

  4. Click Remove X in the pivot table editor to delete the field.

  5. Click Select data range which looks like a small grid in the top right corner of the pivot table editor, to change the range of data used for the pivot table.

If you change or add the original data that makes up your PivotTable, the PivotTable is automatically updated.

Leave a Reply

Your email address will not be published.