Add a calculated field to 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. Add a calculated field named Profit with the formula ='Revenue'*0.3.
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. Add a calculated field named Profit with the formula ='Revenue'*0.3.
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 changeAdd a calculated field named Profit with the formula ='Revenue'*0.3.
Shortcut or faster method
Select the target cell, type or paste the formula in the formula bar, then press Enter.
Expected result
The pivot table groups Revenue by Region and includes a Profit calculated field equal to 30% of Revenue.
Common mistake
Typing the formula as plain text or placing it in the wrong cell.
Troubleshooting
Re-select A1:D6 and repeat the final action. The pivot table groups Revenue by Region and includes a Profit calculated field equal to 30% of Revenue.
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. Add a calculated field named Profit with the formula ='Revenue'*0.3.
- The pivot table groups Revenue by Region and includes a Profit calculated field equal to 30% of Revenue.