Forum Discussion
Link a Row of cells in a sheet to a row of cells in a pivot table
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.
