Adding a field to a pivot table means dragging a column name into one of four zones
A pivot table starts with raw data — rows and columns in a spreadsheet. A field is one of those column headers. When you add a field to a pivot table, you are telling it which columns to use and where to put them: in the row labels, column labels, values area, or filters. The exact steps depend on whether you use Excel or Google Sheets, but the concept is the same in both.
The reason to add fields is to reshape your data so you can see patterns. If you have a spreadsheet of sales by region, product, and month, a pivot table with region in rows, month in columns, and sales totals in the middle lets you spot which regions are strongest in which seasons. Without adding the right fields, you just see a flat list.
Most people get stuck because they do not know which zone each field should go into. This guide walks you through both programs and explains what each zone does.
Key Takeaways
- A pivot table has four zones: Rows, Columns, Values, and Filters — each field you add goes into one of these.
- In Excel, you drag field names from the Field List panel on the right into the zone boxes below it.
- In Google Sheets, you click the field name in the Editor panel and choose which zone to add it to.
- The Values zone must contain numbers (sales, quantities, counts) — text fields go in Rows, Columns, or Filters.
- You can add the same field to multiple zones if you need to see the data broken down in different ways.
How to add a field in Excel
Open your pivot table in Excel. On the right side of the screen, you will see the PivotTable Fields panel. This panel lists every column header from your original data. If you do not see this panel, click anywhere inside the pivot table and it will appear.
At the top of the panel is a list of field names. Below that are four boxes labeled Filters, Columns, Rows, and Values. To add a field, drag its name from the top list into one of these four boxes. For example, if your data has a Region column and you want regions as row labels, drag "Region" into the Rows box. If you want to see sales totals, drag "Sales" into the Values box.
Excel will automatically sum numbers and count text, so if you drag a sales column into Values, it adds them up. If you drag a product name into Values by mistake, it counts how many times each product appears. You can change this later by right-clicking the field in the Values box and choosing a different function — but it is faster to put the right field in the right zone from the start.
To remove a field, drag it out of its box, or right-click it and choose Remove Field. The pivot table updates when ready.
How to add a field in Google Sheets
Open your pivot table in Google Sheets. On the right side, you will see the Pivot table editor. This panel has a section called "Data range" at the top, and below it are four sections: Rows, Columns, Values, and Filters. Each section has an "Add" button.
To add a field, click the "Add" button next to the zone where you want it. A dropdown menu appears showing all available fields. Click the field name. Google Sheets adds it to that zone and the pivot table updates when ready.
If you need to move a field to a different zone, click the field name in its current zone and a menu appears with options to move it. You can also remove it from that menu. Unlike Excel, Google Sheets does not let you drag fields between zones — you have to remove and re-add them.
Understanding the four zones and what goes in each
The Rows zone contains the labels that appear down the left side of your pivot table. If you put Region in Rows, each region becomes a separate row. If you put both Region and Product in Rows, you get regions first, then products nested under each region. Text fields almost always go here.
The Columns zone contains the labels that appear across the top. If you put Month in Columns, each month becomes a separate column. This zone is useful when you want to compare values side by side. You can leave this zone empty if you do not need it.
The Values zone is where numbers go. This zone must contain at least one field, and that field should be numeric — sales, quantity, count, average, or anything you want to calculate. If you put a text field here by mistake, the pivot table counts occurrences instead of adding them up. You can add the same field twice if you want to see it both summed and averaged, for example.
The Filters zone adds dropdown menus above the pivot table. If you put Region in Filters, a dropdown appears that lets you show only certain regions. This is useful when your data is large and you want to focus on a subset. Filters do not change the structure of the table — they just hide rows and columns you do not want to see.
Common mistakes when adding fields
The most common mistake is putting a text field in the Values zone. If you drag Product Name into Values, the pivot table counts how many times each product appears instead of summing anything. The fix is straightforward: move the text field to Rows or Columns, and move a number field into Values.
Another mistake is adding too many fields to Rows or Columns at once. If you add Region, Product, and Month all to Rows, the table becomes hard to read because every combination appears as a separate row. Start with one or two fields and add more only if the table is still clear.
A third mistake is forgetting that you can add the same field twice. If you want to see both the total sales and the average sale per transaction, add Sales to Values twice, then change one copy to Sum and the other to Average. Both will appear in the pivot table side by side.
Changing how a field is calculated
By default, Excel sums numbers and Google Sheets also sums numbers. But sometimes you need a different calculation — an average, a count, a minimum, or a maximum. In Excel, right-click the field in the Values box and choose "Value Field Settings". A dialog opens where you can pick Sum, Average, Count, Min, Max, or other options. In Google Sheets, click the field name in the Values section and choose "Summarize by" from the menu that appears.
This matters because the calculation changes what the numbers mean. If you have sales by salesperson and you sum them, you see total revenue per person. If you average them, you see average transaction size per person. Both are useful — it depends on what question you are trying to answer.
Frequently Asked Questions
Can I add a field that is not in my original data?
No. The pivot table can only use fields (columns) that exist in your source data. If you need a new field, you have to add it to the original spreadsheet first, then refresh the pivot table. In Excel, right-click the pivot table and choose "Refresh". In Google Sheets, the pivot table updates automatically when you change the source data.
What if I add a field and nothing changes in the pivot table?
This usually means the field is empty or contains only blank cells. Check your source data to make sure the column actually has values. If it does, try removing the field and adding it again. If the problem persists, the data might be formatted in a way the pivot table does not recognize — for example, dates stored as text instead of actual dates.
Can I add the same field to multiple zones?
Yes. You can add the same field to both Rows and Values if you want to, though this is uncommon. More often, you add a field to Values twice with different calculations — once summed and once averaged, for example. This shows you both totals and averages in the same table.
How do I know if a field should go in Rows or Columns?
Put fields with few values in Columns (like Month or Region) and fields with many values in Rows. If you put a field with 100 different values in Columns, the table becomes impossibly wide. If you put a field with only 3 values in Rows, you waste vertical space. There is no hard rule — it depends on what you are trying to see.
What happens if I remove a field from a pivot table?
The pivot table recalculates when ready and shows only the remaining fields. Your original data is not affected — removing a field from a pivot table does not delete anything. You can always add the field back if you change your mind.