PC Review

Thread Tools Rate Thread

How to edit pivot table calculated field

Posts: n/a
      15th Jun 2005
How do I get to see or change the definition of one?

Here's the problem - I have a form based on a table.

Some time ago I created a pivot table on it, it has a total field called Rcvd

I put it into a table and right click and look at its properties. the
properties says
"total source field" is Net Receipt. Net Receipt is not a field in my data
source and is not visible on my form anywhere. How do I get at that "field"
and verify or change its definition?

If I try and create a new field called "Net Receipt" it disallows it saying
the field already exists.

William Hite
Office Automation Consultant and Developer
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table, IF function, calculated item versus calculated field NomadPurple Microsoft Excel Misc 1 9th Mar 2010 04:17 PM
Pivot: Calculated Field vs Calculated Item SG Microsoft Excel Worksheet Functions 2 27th May 2007 12:57 PM
Calculated Field and Calculated Item in Pivot Table Fred Smith Microsoft Excel Misc 0 4th Mar 2007 09:15 PM
Pivot Table Formulas Calculated Item / Calculated Field =?Utf-8?B?VmlrcmFtIERoZW1hcmU=?= Microsoft Excel Programming 2 10th Oct 2006 08:45 AM
pivot table formulas for calculated field or calculated item =?Utf-8?B?Vmlja3k=?= Microsoft Excel Misc 3 6th Jun 2006 05:06 AM




All times are GMT +1. The time now is 09:20 AM.