Linking to a cell in a pivot table

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I have three different pivot tables. But the bottom right
cell of eact table is the total for the table.

I need to add the three totals together and put the result
on amother sheet.

How can I do this, when the cells keeps on changing after
each data refresh?
 
Hi

You could do VLOOKUPs on 'Total' (or whatever the total line is called) and
add them together.
 
You can use the GETPIVOTDATA function to extract the grand totals. The
function's arguments vary, depending on the version of Excel you're using.

For Excel 2002, to return the grand total for the data field "Units":

=GETPIVOTDATA("Units",Sheet1!$A$3)+GETPIVOTDATA("Units",Sheet2!$A$3)
+GETPIVOTDATA("Units",Sheet2!$A$3)

Look in Excel's online help for examples for your version, and there are
a couple of examples on my web site:

http://www.contextures.com/xlPivot06.html#Formula
 
Back
Top