How to Display Percentage of Total in Pivot Table in Google Sheets

To display the percentage of the total in a pivot table in Google Sheets, follow these steps:

1. Prepare your data in a Google Sheet. Make sure your data has headers for each column.
2. Select your data, including the headers. You can do this by clicking on the top-left corner of your data and dragging to the bottom-right corner.
3. Click on "Data" in the menu, and then click "Pivot table." A new sheet will be created with a pivot table.
4. In the "Rows" section of the Pivot table editor, click on "Add" and choose the row header you want to display in your pivot table.
5. In the "Columns" section, click on "Add" and choose the column header you want to display in your pivot table.
6. In the "Values" section, click on "Add" and choose the value you want to display as a percentage of the total.
7. Click on the drop-down arrow next to the "Summarize by" option and choose "SUM."
8. Click on the drop-down arrow next to the "Show as" option and choose "% of grand total."

Now, your pivot table will display the percentage of the total for the chosen value.

Example

Let's say we have the following data:

Product | Price | Quantity
--------|-------|---------
A       | 10    | 5
B       | 20    | 4
C       | 15    | 6
D       | 25    | 3

We want to create a pivot table showing the percentage of the total quantity sold for each product.

1. Select the data, including headers (A1:C5).
2. Click on "Data" in the menu, and then click "Pivot table." A new sheet with a pivot table will be created.
3. In the "Rows" section, click on "Add" and choose "Product."
4. In the "Values" section, click on "Add" and choose "Quantity."
5. Click on the drop-down arrow next to the "Summarize by" option and choose "SUM."
6. Click on the drop-down arrow next to the "Show as" option and choose "% of grand total."

The pivot table will now display the percentage of the total quantity sold for each product, like this:

Product | % of grand total
--------|-----------------
A       | 27.78%
B       | 22.22%
C       | 33.33%
D       | 16.67%