Pivot Table (Deleting a formula field)

[Deano]

Hi all

Possibly a really dumb question, but I have created a few formula fields in my pivot table and now want to delete one of them.

I know that I can drag the item off the pivot table in the wizard, but how do I completely delete the field as though I had not created it?

Regards & thanks.

 

[pgc01]

Hi deano

Right-click on the PT, choose Formulas>Calculated Field
In the name box write the name of the field you want to delete.
Use the button Delete.

Hope this helps
PGC

 

[Deano]

Hi PGC

Excellent works perfectly, thanks a mil.

regards
Deano