D
Dave Wolfe
I'm doing pivot tables in Excel 2002. When I use a cell
from the pivot table in an equation outside of the pivot
table it inserts the path to the original data not the
cell I selected. The calculations are correct but I just
want the cell ID to be in the equation. Do you know a way
to do this without typing in the cell ID manually.
Example: Say I want to add cell P50 plus P34 from a pivot
table. If I click in the cell P34 to include it in the
equation I get =P50+GETPIVOTDATA("Hours",$L$3)
Instead of what I want =P50+P34.
from the pivot table in an equation outside of the pivot
table it inserts the path to the original data not the
cell I selected. The calculations are correct but I just
want the cell ID to be in the equation. Do you know a way
to do this without typing in the cell ID manually.
Example: Say I want to add cell P50 plus P34 from a pivot
table. If I click in the cell P34 to include it in the
equation I get =P50+GETPIVOTDATA("Hours",$L$3)
Instead of what I want =P50+P34.