Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / November 2006

Tip: Looking for answers? Try searching our database.

Pivot Table default field setting

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
BK - 15 Nov 2006 12:03 GMT
Working on Excel 2003

Machine One:  When dragging fields to the data section of a pivot table, the
default function is "sum."

Machine Two:  When dragging fields to the data section of a pivot table, the
default function is "count."

Question:  Is there a way to set the default function of the field setting
prior to creating the pivot table?

Another question:  Is there a way to globally change the field setting after
dragging all to the data section?  I am comparing monthly data, so I have 12
fields that I drag to the data section (Jan, Feb, Mar, etc)  As of now, I am
changing them one at a time from "count" to "sum" but there has to be an
easier solution.

Any help???
Dave Peterson - 15 Nov 2006 14:44 GMT
The default depends on the field that you drag to the data area.

If all the cells are numeric, then you'll see "Sum of".  If any of the cells
contain text or are empty, then you'll see "Count of".

I don't know of anyway of changing the default, but Debra Dalgleish has an addin
that offers lots of features--including changing this data field summary
function:

http://contextures.com/xlPivotAddIn.html
and
http://contextures.com/xlPivotAddIn02.html

> Working on Excel 2003
>
[quoted text clipped - 14 lines]
>
> Any help???

Signature

Dave Peterson

BK - 15 Nov 2006 22:22 GMT
It's helpful to know the reason that "count" is the function if any cells in
the data range are blank.  Thanks.

> The default depends on the field that you drag to the data area.
>
[quoted text clipped - 35 lines]
>>
>> Any help???

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.