How to Show Pivot Table Fields in Google Sheets

Building a pivot table in Google Sheets is a great first step, but the real analysis happens when you start arranging your data fields. If you've ever set up a pivot table only to watch the editor pane disappear, leaving you unable to add or move your rows and columns, you know how frustrating it can be. This guide will show you exactly how to find, show, and manage your pivot table fields so you can take full control of your data analysis.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Understanding the Pivot Table Editor: Your Control Panel

The moment you create a pivot table in Google Sheets, a side pane called the "Pivot table editor" should appear. This editor is your command center. It's where you tell Google Sheets how to organize, summarize, and display your data from your source sheet. If you don't understand how this pane works, you won't be able to build a useful report.

The editor is divided into four main areas, each serving a distinct purpose:

• Rows: Fields you add here will create the row labels for your table. For example, if you're analyzing sales data, you could drag the "Product Category" field here to create a separate row for each category (e.g., Electronics, Apparel, Home Goods).
• Columns: Fields placed here become the column headers. Continuing the sales example, you might add the "Region" field to see sales performance broken down by each location (e.g., North, South, East, West) across the top.
• Values: This is where you put the numerical data you want to calculate. It's the "what" you are measuring. A field like "Revenue" or "Units Sold" would go here. By default, Google Sheets will often sum a value, but you can choose to summarize it in other ways (like COUNT, AVERAGE, MAX, or MIN).
• Filters: The filter section allows you to narrow down your dataset without changing the structure of your table. For instance, you could add the "Salesperson" field here and then filter the entire table to show data for just one or two specific salespeople.

Beneath these four areas, you'll see a list of "Suggested" fields and the rest of your column headers from your source data, ready to be dragged and dropped into the sections above.

Where Did My Pivot Table Fields Go? (And How to Get Them Back)

This is easily the most common point of confusion for new pivot table users. You build your table, click on another cell to grab some data, and suddenly the editor pane is gone. Your pivot table is still there, but your ability to change its fields has vanished.

Don't panic! Bringing it back is simple.

The Pivot Table Editor is context-aware. This means it only appears when you have actively selected a cell within the pivot table itself. If you click anywhere outside of it - on your source data sheet, in a blank cell, or even just another cell on the same sheet - the editor will disappear to save screen space.

Here’s how to make your pivot table fields reappear:

1. Navigate to the sheet containing your pivot table.
2. Click on any cell inside the pivot table area. It can be a header, a value, or a total.

That's it. As soon as you select a cell within the table boundaries, the Pivot Table Editor should pop back up on the right side of your screen, ready for you to continue your work. If for some reason it doesn't, look for a small "Edit" button that might appear beneath the table after you click on it.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

A Step-by-Step Guide to Adding and Managing Fields

Let's walk through building a simple report to see how these fields work together. Imagine you have a spreadsheet with sales data containing these columns: Order Date, Region, Product, Sales Rep, and Revenue.

Step 1: Open the Pivot Table Editor

First, make sure your editor is visible by clicking anywhere inside your newly created (and probably empty) pivot table. You'll see the editor pane on the right with the sections for Rows, Columns, Values, and Filters.

Step 2: Add Row Fields

You want to see how each region is performing. Find the Region field in the list of available columns on the right side of the editor. Click and drag it to the 'Rows' section. Alternatively, you can click the 'Add' button next to the Rows heading and select Region from the list.

Instantly, your pivot table will populate with a unique row for each region listed in your source data (e.g., North, South, East, West).

Step 3: Add Column Fields

Next, you want to see which products are selling in those regions. Find the Product field and drag it into the 'Columns' section. Your pivot table will expand, creating columns for each unique product and placing them alongside your region rows.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 4: Add and Summarize Value Fields

Now it's time to fill the table with data. The metric you want to measure is revenue. Locate the Revenue field and drag it to the 'Values' section.

Google Sheets will automatically calculate the revenue for each product within each region. By default, it uses the SUM function. However, if you wanted to see the average sale amount instead, you could click the dropdown under 'Summarize by' within the Revenue value field and select AVERAGE.

Step 5: Add a Filter

Let's say your manager only wants to see the performance of a specific sales rep, "Jane Doe." Drag the Sales Rep field to the 'Filters' section. A new filter box will appear below your table. Click on it, and you'll see a list of all your sales reps with checkboxes. Uncheck 'Select all', then find and check the box for "Jane Doe" to filter the entire pivot table to show only her sales data.

Step 6: Reordering and Removing Fields

Your analysis needs are fluid, and your pivot table should be too.

• To reorder, simply drag fields within a section. For instance, if you added Product to the Rows section after Region, you can drag Product above Region to group by products first.
• To remove, simply click the 'X' on the right side of any field you've added to a section. The pivot table will update immediately, removing that dimension from your report.

Practical Tips for Working with Pivot Table Fields

Once you've mastered the basics of adding, moving, and removing fields, you can use these tips to make your reports even more insightful.

Rename Your Headers for Clarity

When you add "Revenue" to the Values section and summarize by SUM, the header will read "SUM of Revenue." This is functional but can look clunky in a presentation. You can easily change this. Just click directly on the header cell in the pivot table itself and type a more descriptive name, like "Total Sales" or "Revenue ($)." This will not affect your source data.

Sort Your Data to Find Top Performers

By default, your row labels are typically sorted alphabetically. It's often more useful to sort them by a value. In the 'Rows' section of the editor, find your Region field. Click the 'Sort by' dropdown (it usually defaults to Region) and change it to SUM of Revenue. Then, choose 'Descending' order to list your top-performing regions at the top.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Group Data to See Trends

If you have a date field like 'Order Date' in your Rows section, you're going to get a row for every single day, which isn't very helpful for spotting trends. Google Sheets makes it easy to group them. Right-click on any of the date values in the pivot table itself and select "Create pivot date group." You can then choose to group them by 'Month', 'Quarter', 'Year', or a combination.

Use Calculated Fields for Deeper Analysis

Sometimes the metric you need isn't in your source data. For example, what if you have Revenue and Units Sold fields, but you want to find the Average Price per Unit? You can create a calculated field directly in the pivot table.

1. In the Pivot Table Editor, go to the 'Values' section and click 'Add.'
2. Select 'Calculated Field.'
3. A new box will appear. In the 'Formula' field, you can enter your custom formula using your other field names. It’s important to wrap the field names in single quotes. For our example, enter:

= 'Revenue' / 'Units Sold'

1. You can also specify how to summarize it (in this case, 'Custom' is fine), and then click away. Your new calculated field will appear in the table.

This allows you to create new metrics on the fly without having to add more columns to your original raw data sheet.

Final Thoughts

Learning to show and manipulate fields in the Pivot Table Editor is the key to turning a static block of data into a dynamic analysis tool. By understanding how to use rows, columns, values, and filters, you can slice and dice your information to uncover trends, answer questions, and build clear, concise reports right inside Google Sheets.

While mastering pivot tables is a huge leap forward, the process still often starts with pulling data from many different places. Manually exporting CSVs from your sales, marketing, and ad platforms just to combine them in a spreadsheet takes up valuable time. We built Graphed to solve this by connecting directly to all your data sources – like Google Analytics, Shopify, Facebook Ads, and Salesforce – in one click. You can then build powerful, real-time dashboards just by describing what you want in plain English, getting the cross-platform insights you need in seconds, not hours.