getpivotdata and autofill calculation

  • Thread starter Thread starter alicia
  • Start date Start date
A

alicia

I am using Excel XP and often perform calculations using
pivot table data. As these are often quite large I copy
the formulas down, but with XP this does not work, it just
repeats the result from the first cell. The following is
the way a simple calculation appears now.

=GETPIVOTDATA("Sum of Total Value",$A$43,"Shipment
Year",1992)-GETPIVOTDATA("Sum of Total
Value",$A$43,"Shipment Year",1991)

I have removed the dollar signs, but his makes no
difference as this is not the actual cell reference where
the data is. It references the shipment year whereas the
calculation is actually on value. (Changing the year to
a cell reference does not work either.)

Can anyone help?

I have tried using paste special - paste formulas, but
that doesn't work.
 
In Excel 2002, a GETPIVOTDATA formula is automatically created when you
link to a cell in a pivot table.

You can choose Tools>Customize, and from the Data category on the
Commands tab, add the Generate GetPivotData command to one of your
toolbars. Use this button to toggle the feature on and off.

Or, you can type an equal sign, and type the cell reference, instead of
clicking on the cell to reference it.
 
Back
Top