≡ Menu

Amending Calculated Pivot Fields

If you can create a user-defined calculated field for your pivot table you really need to know how to amend those calculated pivot fields as well:
Updating Calculated pivot table fields

– Click on any pivot table field
– Go to Analyse
– Select Fields, Items & Sets
– Click Calculated Field
– Use the drop down to select your calculated field
– Amend or re-write the formula completely
– Click OK to finish

Doctor Moxie

An Article By -

NHS Accountant with geeky tendencies - serial blogger on subjects varying from Excel, Raspberry Pi, productivity, allotment gardening and running. The ExcelPivots blog is reserved for Excel topics.

Comments on this entry are closed.

%d bloggers like this: