+ Reply to Thread
Results 1 to 2 of 2

Summarize Value Field Settings Groups

Hybrid View

criss lupher Summarize Value Field... 11-30-2011, 12:48 PM
arthurbr Re: Summarize Value Field... 11-30-2011, 01:31 PM
  1. #1
    Registered User
    Join Date
    11-30-2011
    Location
    Dallas, TX
    MS-Off Ver
    Excel 2007
    Posts
    1

    Summarize Value Field Settings Groups

    I created a pivot table and want to change the value field settings for mulitple cells without having to change one one by one. I have right clicked and went to field settings and made the change, but it only changed from 'count' to 'sum' for one of the 'Source Name'. Is there a way that I can change all of the fields from 'count' to 'sum' for all of the 'Source Name's' without having to choose each one? Also, how can I copy and paste a print screen in this thread? Using a copy and paste of the print screen would be much easier than explaining the problem.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,326

    Re: Summarize Value Field Settings Groups

    Hi and welcome to the board

    You can attach a sample sheet the same way you attached the Word doc

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1