P
Patricia
I use Excel 2000 at home and Excel 2002 at the place where I
volunteer. I've created a spreadsheet of items including quantity,
unit cost, total cost (quantity * total cost). In excel 2000 I can
create a pivot table that correctly sums the "total cost" column.
In excel 2002, the pivot table does not correctly sum the "total cost"
column.
The workaround I've found is to add a new column, copy the total cost
field and "paste special" the values into the new column. Excel 2002
pivot table does correctly sum this new column.
Is there any other way to correct this?
thanks
Patricia
volunteer. I've created a spreadsheet of items including quantity,
unit cost, total cost (quantity * total cost). In excel 2000 I can
create a pivot table that correctly sums the "total cost" column.
In excel 2002, the pivot table does not correctly sum the "total cost"
column.
The workaround I've found is to add a new column, copy the total cost
field and "paste special" the values into the new column. Excel 2002
pivot table does correctly sum this new column.
Is there any other way to correct this?
thanks
Patricia