Show percentages in a pivot table in Google Sheets
Create a pivot table on a new sheet from A1:D6. Put Region in Rows and Revenue in Values summarized by SUM. For the Revenue value, set Show as to % of grand total.
Verified by PhilisAbout 60 secondsCreate a pivot table on a new sheet from A1:D6. Put Region in Rows and Revenue in Values summarized by SUM. For the Revenue value, set Show as to % of grand total.
Step-by-step
Select the targetCreate a pivot table on a new sheet from A1:D6.
Complete the next actionPut Region in Rows and Revenue in Values summarized by SUM.
Apply the changeFor the Revenue value, set Show as to % of grand total.
Shortcut or faster method
Select the full target range first. This avoids repeating the same change cell by cell.
Expected result
The pivot table groups by Region and shows each Revenue total as a percentage of the grand total.
Common mistake
Starting with the wrong cell or range selected.
Troubleshooting
Re-select A1:D6 and repeat the final action. The pivot table groups by Region and shows each Revenue total as a percentage of the grand total.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Region | Owner | Category | Revenue |
| North | Anna | Software | 120 |
| South | Ben | Services | 180 |
| North | Cara | Services | 240 |
| West | Dev | Software | 210 |
| South | Eva | Software | 160 |
Video transcript
- Open the prepared Practice spreadsheet.
- Select the target. Create a pivot table on a new sheet from A1:D6.
- Complete the next action. Put Region in Rows and Revenue in Values summarized by SUM.
- Apply the change. For the Revenue value, set Show as to % of grand total.
- The pivot table groups by Region and shows each Revenue total as a percentage of the grand total.