Last Updated on November 1, 2023 by Jake Sheridan

In this tutorial, you will learn how to add a Pivot Table Calculated Field in Google Sheets.

One of the most powerful features of the pivot table is the ability to calculate fields. A calculated field is a column that is generated by a formula. This means that you can generate new data from existing fields in your pivot table.

For example, you may want to create a calculated field to compute how much tax should be collected for a given purchase.

In this guide, we will show you how to add your own calculated fields to a pivot table in Google Sheets.

## How to Create a Calculated Field in a Google Sheets Pivot Table

Here’s how to create a calculated field in a Google Sheets pivot table.

### Step 1

First, select the cell range we want to convert into a Pivot Table. If applicable, you may use the Ctrl + A shortcut to quickly select a table in your spreadsheet.

### Step 2

Next, click on the Pivot table option found under the Insert menu.

### Step 3

You may choose to either create the new pivot table in a new sheet or an existing sheet. After selecting your preferred destination, click on Create to continue.

### Step 4

We can now jump straight to creating a calculated field in our new Pivot Table.In the Pivot table editor, click on the Add button next to the Values label.

### Step 5

Select the Calculated Field option from the drop-down menu.

### Step 6

You will notice a new element has appeared under the Values label. Select the formula text box to start writing our formula.

### Step 7

Start the formula with an equal sign. When creating a calculated field, you may refer to specific fields using the names indicated in the header.

In this example, my calculated field simply returns 2% of the amount for that given row. We’ll also use the SUM option for summarizing.

### Step 8

Since we’ve only added a single calculated field, our Pivot Table returns the value equal to the sum of 2% of all transaction amounts.

### Step 9

We can rename our calculated field by clicking on the header and typing our preferred name.

### Step 10

Now that we’ve set up our new calculated field, we can continue adding new fields to our Pivot Table.

## Summary

This guide should be everything you need to know to start creating your own calculated fields in a Google Sheets pivot table.

You may make a copy of this example spreadsheet to test it out on your own.