GETPIVOTDATA function in Google Sheets
A pivot table is already on the "Pivot report" sheet. In Practice!G2, enter exactly =GETPIVOTDATA("SUM of Revenue",'Pivot report'!A1). Do not edit the source data or pivot table.
Verified by JosephineAbout 60 secondsA pivot table is already on the "Pivot report" sheet. In Practice!G2, enter exactly =GETPIVOTDATA("SUM of Revenue",'Pivot report'!A1). Do not edit the source data or pivot table.
Step-by-step
Select the targetA pivot table is already on the "Pivot report" sheet.
Apply the changeIn Practice!G2, enter exactly =GETPIVOTDATA("SUM of Revenue",'Pivot report'!A1).
Shortcut or faster method
Select the target cell, type or paste the formula in the formula bar, then press Enter.
Expected result
Practice!G2 returns the pivot table's total revenue.
Common mistake
Applying the change to more rows, columns, or cells than the task specifies.
Troubleshooting
Re-select G2 and repeat the final action. Practice!G2 returns the pivot table's total revenue.
Example spreadsheet data
This is the clean fixture used for the verified run.
| Region | Owner | Category | Revenue | Metric | |
| North | Anna | Software | 120 | Pivot total | |
| 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. A pivot table is already on the "Pivot report" sheet.
- Apply the change. In Practice!G2, enter exactly =GETPIVOTDATA("SUM of Revenue",'Pivot report'!A1).
- Practice!G2 returns the pivot table's total revenue.