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.
How To Add Pivot Table Calculated Field in Google Sheets
Google Sheets pivot tables are a powerful tool that can help you summarize and explore data 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.
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.
Next, click on the Pivot table option found under the Insert menu.
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.
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.
Select the Calculated Field option from the drop-down menu.
You will notice a new element has appeared under the Values label. Select the formula text box to start writing our formula.
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.
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.
We can rename our calculated field by clicking on the header and typing our preferred name.
Now that we’ve set up our new calculated field, we can continue adding new fields to our Pivot Table.
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.