Hi,
I have created a Pivot Table using data that's in a range assigned as a Table.
When setting up the PT I inserted a few calculated fields that used data in the associated Table. The calculated fields returned the correct results but when I tried to edit the formulae in the calculated field (PivotTable Tools -> Options -> Fields, Items & Sets -> Calculated Field) I can't see the formulae.
Can someone please tell me how to edit the formulae?
Thanks
Last edited by andrewc; 12-10-2013 at 06:46 AM.
hi andrewc. in that window you mentioned, there is a dropdown for the Name field. select that & you should see your calculated Field. if you didn't change the name, it'll probably be named Field1 by default. you can then edit the formula. upload a sample file if you can't find it.
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
it should be in the Top dropdown "Name" - did you name the calculated field
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thanks very much!
your welcome
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks