# How to Add & Use Calculated Fields in Google Sheets Pivot Tables

Calculated Fields are very useful when it comes to summarising the data in Google Sheet Pivot tables. The main purpose of Calculated Fields is that it allows you to process your data in order to create more tailored Pivot table results. With the help of Custom formulas, one can present summary metrics in the Pivot table using calculated fields without making any changes in the actual dataset. In this article, let us understand how to add and use the Calculated Fields with the Google Sheet tips provided on this page. Read on to find more.

## How to Create Pivot Tables in Google Sheets?

Let us consider the following dataset which represents the sales data of each division.

Now follow the steps listed below to create a Pivot table for the above dataset.

• Step 1: Click on the Data tab from the menubar.
• Step 2: Now choose “Pivot Table” from the drop-down menu.

• Step 3: You should now see a window asking whether you want to place your pivot table into an existing sheet or create a new one. Choose your preferred option. It’s always advisable to make one in a new sheet for clarity.

• Step 4: Click on the “Create” button.
• Step 5: Now the Pivot table will be created in the new sheet. The Pivot table will look like the following image at this stage.

• Step 6: A grid of ‘Rows, Columns, and Values‘ should be displayed. You may now begin populating your pivot table with the information you desire. A Pivot Table Editor should appear on the right side of the window. This will assist you in determining what should be included in your pivot table.

Now let us understand how to add the calculated fields using the SUM function in Google Sheets with the help of the steps given below:

• Step 1: Select the pivot table by clicking on it.
• Step 2: Click Add next to “Values” on the side panel.
• Step 3: Select the Calculated field box from the drop-down menu.

• Step 4: To use SUM to calculate a value, click SUM next to “Summarize by.
• Step 5: To use a custom formula to calculate a value, follow these steps: Enter a formula in the field that displays. In our case the formula is =SUM(arrayformula(‘Number of Units’*’Price Per Unit’))/sum(‘Number of Units’)
• Step 7: Then click Custom next to “Summarize by.

• Step 8: Click Add in the bottom right corner to add a new column.

Now you can see the results as shown below: