Pivot Table calculated item


C

csdjj

I'm using Excel 2002. I have a very simple pivot table with 'Product' in the
row and 'Cost' in the data.

The problem is, I was playing around trying to learn calculated items and
created a calculated item that I don't need -- but is now causing me problems.

Since I've created the calculated item, I can no longer have a data field in
two locations (e.g., having 'Product' not only in the row but also in the
data area).

I've tried to delete the calculated field but it just gives me an error that
says 'Pivot Table field name is not valid . . . '

If I copy the source data into a completely new spreadsheet and re-create
the pivot table it works fine so I know the calculated field is causing the
problem. Can someone tell me how to get rid of it?

(Even though the example I used above is a simple pivot table, I actually
have about 15 complicated pivot tables in this spreadsheet so re-creating
them all would be a big pain.)

Thanks for your help!
 
Ad

Advertisements

J

John Bundy

try right clicking on the table and go to the wizard, on the left you will
see a layout button, you should be able to find it and remove it there. If
that doesn't get it then check out Debra's site, it has everything you need
on Pivot Tables.
http://www.contextures.com/tiptech.html
 
C

csdjj

Unfortunately, right-clicking didn't work -- the field in question doesn't
show up.

I also checked Debra's site but didn't see anything there that would help.

Anybody else have an idea??
 
D

Debra Dalgleish

To remove a calculated item:
In the pivot table, select one of the labels for the pivot field that
contains the calculated item.
On the PivotTable toolbar, click PivotTable>Formulas>Calculated Item
In the Name dropdown, select the calculated item that you want to delete
Click the Delete button
Click OK
 
Ad

Advertisements

C

csdjj

Unfortunately, this doesn't work. As soon as I click the "delete" button it
gives me an error that starts with, "The Pivot table field name is not valid
.. . . "
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top