Pivot table formulas

S

sduffield

How do I delete the calculated fields that I added to a pivot table? The
field list for the pivot table doesn't seem to be modifiable.

Thanks,
Sduffield
 
J

Jim Thomlinson

How you do it depends on which version of XL you have but essentially the
spot where you created the calculatied field is the same spot where you will
delete it.

Pivot table | Formulas | Calculated Fields
Select the Calculated Field and then hit the delete button
 

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

Similar Threads

Delete Pivot Table Formula 1
Dealing with a Pivot Table (when I don't want to) 0
Dates In Excel 5
Doughnut Chart linked with the slicer in the pivot table 0
Pivot Table cell values 1
Slicers and Calculated Items in Pivot Table 2
Excel does not accept text format! 0
Power Pivot. Yikes. 0

Top