---
title: "Create & use pivot tables - Google Docs Editors Help"
url: https://stacklist.com/card/829425b4-5407-4924-8099-c8f7ba2fabe2
source_url: "https://support.google.com/docs/answer/1272900"
stack: https://stacklist.com/c/business/stack/c63a8f97-5e08-4630-8e71-f2794bad0e8b
summary: "Pivot tables in Google Sheets allow users to narrow down large datasets and analyze relationships between data points. This guide covers creating, editing, and using calculated fields with formulas to summarize and filter data effectively."
tags: "pivot-tables, google-sheets, data-analysis, spreadsheet, tutorial, calculated-fields, data-visualization"
key_entities: "Google Sheets (technology), Google Workspace (technology), pivot tables (concept), calculated fields (concept), GETPIVOTDATA function (concept)"
classification: "tutorial"
content_hash: "sha256:9b011f7899d726d330b862f58e306414b165ffc897dfe5b268892965d0811a8f"
acp_version: "0.2"
token_counts_approximate: 1034
visibility: public
agent_accessible: true
status: "final"
---

# Create & use pivot tables - Google Docs Editors Help

Create & use pivot tables Want advanced Google Workspace features for your business? Try Google Workspace today! You can use pivot tables to: Narrow down a large data set. See relationships between data points . For example, you could use a pivot table to analyze which salesperson produced the most revenue for a specific month. Add or edit pivot tables On your computer, open a spreadsheet in Google Sheets . Select the cells with source data you want to use. Important: Each column needs a header. In the menu at the top, click Insert Pivot table . Click the pivot table sheet, if it’s not already open. In the side panel, next to "Rows" or "Columns," click Add , then choose a value. Sometimes, you'll see recommended pivot tables based on the data you choose. To add a pivot table, under "Suggested," choose a pivot table. High confidence pivot table suggestions will be automatically inserted upon pivot table creation. To turn off pivot table suggestions: At the top, click Tools Suggestion controls . Turn off Enable Pivot table suggestions . In the side panel, next to "Values," click Add , then choose the value you want to see over your rows or columns. You can change how your data is listed, sorted, summarized, or filtered . Next to what you want to change, click the Down Arrow . Change or remove data On your computer, open a spreadsheet in Google Sheets . Click the pop-up Edit button underneath the pivot table. In the side panel, change or remove fields: To move a field , drag it to another category. To remove a field, click Remove . To change the range of data used for your pivot table, click Select data range  . To clear all fields, click Clear all . Note: The pivot table refreshes any time you change the source data cells it’s drawn from. See cell details You can look at the source data rows for a cell in a pivot table. On your computer, open a spreadsheet in Google Sheets . Click the pop-up Edit button underneath the pivot table. Double-click the cell you want to look at in more detail. You'll see a new sheet with the cell’s source data. Add calculated fields with SUM or a custom formula Adding calculated fields allows you to create new metrics directly within a pivot table. This feature has a structured formula editor, column insertion menus, function insertion menus, and real-time formula validation before saving. On your computer, open a spreadsheet in Google Sheets . Click the pop-up Edit button underneath the pivot table. In the side panel, next to "Values," click Add click Calculated field . A structured formula editor appears to assist in writing and validating formulas with column and function insertion menus. Calculate a value with SUM: Enter the column you would like to summarize or directly select under the Columns tab. If the formula syntax is valid, you’ll see a green checkmark in the bottom right of the input box. If the formula syntax is not valid, you’ll see a red exclamation mark and need to select another column to summarize. Custom formula: In the Pivot table editor, next to Values , click Add Calculated field . Add a name for your calculated field and enter your formula in the editor field or select a function from the Functions tab. Optional: You can also select a column from the Columns tab to help with formula writing. Under the input box, next to “Summarize by,” choose Custom . On the bottom right, click Add and the new column will appear. Tip: To write custom formulas, you can use: Other columns, for example, =sum(Price)/counta(Product) where " Price " and " Product " are fields in the pivot table or an underlying table (available with Connected Sheets.) Google Sheets functions . Important: If you use field values with spaces, make sure to use quotations around them in your custom formula. For example: ="h sdf" . Example Make a copy   Related articles Customize a pivot table GETPIVOTDATA function   To learn about Spreadsheets, Databases, and Query Languages, click the button below: Tutorial: Intro to Spreadsheets, Databases, and Query Languages Computer Android phone & tablet iPhone & iPad More