Forum Discussion
Solved
Link a Row of cells in a sheet to a row of cells in a pivot table
I have a pivot table where the the number of rows could change when the table is updated (due to changes in the underlying data). In a different sheet in the same workbook, I want a row of cells ...
ripalp In the "other worksheet" select the cell where you want the pivot table total to show. Press = to start a formula, click on the sheet that has the pivot table and select the total.
This should create a formula similar to this:
=GETPIVOTDATA("value",Sheet1!$G$8)
where "value" is the field name of the total selected and the cell reference is the starting point of the pivot table. Repeat this for each cell on the Grand Total row you want to include.
ripalp In the "other worksheet" select the cell where you want the pivot table total to show. Press = to start a formula, click on the sheet that has the pivot table and select the total.
This should create a formula similar to this:
=GETPIVOTDATA("value",Sheet1!$G$8)
where "value" is the field name of the total selected and the cell reference is the starting point of the pivot table. Repeat this for each cell on the Grand Total row you want to include.
thanks!