ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot table formulas (https://www.excelbanter.com/excel-discussion-misc-queries/262622-pivot-table-formulas.html)

sduffield

Pivot table formulas
 
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

Jim Thomlinson

Pivot table formulas
 
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
--
HTH...

Jim Thomlinson


"sduffield" wrote:

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



All times are GMT +1. The time now is 04:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com