Google Sheets Calculated Field Percentage of Total in Pivot Table

Suppose you are working on a project where you need to keep track of the profit or sales percentage of your company. But tracking everyday percentages is not only challenging but also after some time when the dataset is quite big this part is nearly impossible to complete manually. Moreover, you can also track the data easily by using a pivot table as a pivot table can summarize data easily. In this article, we will learn how to get Google Sheets calculated field percentage of total in pivot table. So, let’s start.

The above screenshot is the overview image to calculate the percentage of Total in google sheets. You will know more about the pivot table and this process after you go through the total article.

Table of Contents

A Sample of Practice Spreadsheet

You may copy the spreadsheet below and practice by yourself.

Calculating Percentage of Total Through Pivot Table

What Is Pivot Table

A pivot table is a tool that summarizes the data with the selected rows, columns, values, etc. For example, if your dataset contains daily profit and by the end of the month you need to summarize your data Then, the pivot table is the best way to calculate the value. With a Pivot table, you can calculate the sum of data, count data, and summarize data. It is useful because It can analyze data as easily as analyzing numbers.

Step by Step Procedures to Calculate Field Percentage of Total in Pivot Table in Google Sheets

The Dataset below contains Company Name and Profit. Here, we will show how to calculate field percentage of total profit in pivot table. So, let’s follow the steps below.

Step 1: Create a Pivot Table

Here, we will create a pivot table to insert the data in the table,

First, Select the dataset with the header column so the range is B4:C10.

Then, select Insert >> Pivot table from the menu bar as below.

After that, “Create pivot table” window will pop up. With the selected area of the dataset.
Now, select New sheet from “Insert to” and click the Create button to create a pivot table.

Following this, a new pivot table is created in another sheet.

Step 2: Modify Pivot Table

Now, we will edit the pivot table to get the percentage value of the total.

Now, put the data into “Pivot table editor” below to get the percentage of total profit.

Therefore, select Add beside Rows and options will pop up as below.
Complete this part by selecting Company Name, so that the company name appears in the row.

Now the company name is added to the row and select Show totals so that it shows the total value.

In the end, the pivot table will show values as follows.

Now, similarly, select “Add” beside “Values” and select Total Profit (Million) to complete the pivot table.

Therefore, the pivot table will show the value as below.

After that, select “% of grand total” from “Show as” so that, it shows the percentage of total profit.

Finally, the pivot table is complete and shows the percentage of total profit.

Things to Remember

Once you create the pivot table you cannot edit the main data.
A pivot table is useful when the dataset is huge and complex. It will simplify your work.
The “Edit” option will only appear when the “Pivot table editor” is not shown in the google sheets.

Conclusion

In this article, we explained how to find Google Sheets calculated field percentage of total in pivot table with proper steps. Hopefully, the method will help you to apply these features to your own dataset. Please let us know in the comment section if you have any further queries or suggestions. You may also visit our OfficeWheel blog to explore more Google Sheets-related articles.