G
gschimek
I have a user who has an excel spreadsheet using Pivot Tables that wa
created in Excel 2000. She just got Excel XP and her pivot tabl
calculations are working differently. I'll try to explain:
She has two columns of data that are calculated based on the pivo
table information. She wants to create a formula in a new column tha
divides one column by another. When she would type = and then click o
the first cell, then / and click on the second field, in Excel 2000 sh
would automatically get a formala that was similar to =E5/D5.
But when she does the same thing in Excel XP she gets a formula simila
to:
=GETPIVOTDATA("Sum of weekl
contribution",$A$3,"UPC","1111111111","Prime Item Desc","PRODUC
NAME","Prime Size Desc","10 OZ")/GETPIVOTDATA("Count of Stor
Nbr",$A$3,"UPC","1111111111","Prime Item Desc","PRODUCT NAME 2","Prim
Size Desc","10 OZ")
Both calculations give the same answer, but when the XP version i
filled down, it calculates the same exact answer, instead o
calculating on the fields relative to it's position.
In Excel XP, if instead of clicking on the cells she wants to calculat
from, she enters in =E5/D5 it calculates correctly, and filling th
column down also calculates correctly.
Is there a setting or something that can be changed to make this wor
like it did in Excel 2000? Please let me know if I need to clarif
anything. It's a little difficult to explain without seeing it
created in Excel 2000. She just got Excel XP and her pivot tabl
calculations are working differently. I'll try to explain:
She has two columns of data that are calculated based on the pivo
table information. She wants to create a formula in a new column tha
divides one column by another. When she would type = and then click o
the first cell, then / and click on the second field, in Excel 2000 sh
would automatically get a formala that was similar to =E5/D5.
But when she does the same thing in Excel XP she gets a formula simila
to:
=GETPIVOTDATA("Sum of weekl
contribution",$A$3,"UPC","1111111111","Prime Item Desc","PRODUC
NAME","Prime Size Desc","10 OZ")/GETPIVOTDATA("Count of Stor
Nbr",$A$3,"UPC","1111111111","Prime Item Desc","PRODUCT NAME 2","Prim
Size Desc","10 OZ")
Both calculations give the same answer, but when the XP version i
filled down, it calculates the same exact answer, instead o
calculating on the fields relative to it's position.
In Excel XP, if instead of clicking on the cells she wants to calculat
from, she enters in =E5/D5 it calculates correctly, and filling th
column down also calculates correctly.
Is there a setting or something that can be changed to make this wor
like it did in Excel 2000? Please let me know if I need to clarif
anything. It's a little difficult to explain without seeing it