Pivot Table default (Sum or Count)
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Pivot Table default (Sum or Count)

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    rvences
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    My pivot tables ssem to have a mind of their own when it comes to summarizing numbers. Occasionally my pivots will sum my numerical data by default. On other occasions it will count my numerical data by default. It's very annoying to manually adjust all my fields from "count" to "sum" formulas. Is there a setting that allows me to choose "sum" as my default selection for summarizing data? Please help!!

    Thanks

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sunny, spring-like Hull
    Posts
    3,339
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Sum is the default if your chosen field contains nothing but numbers. If *any* of the data isn't a number, even if it's a blank cell, then the default will come up as Count.

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Millbank, London, UK
    Posts
    1,790
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    so this is why mine default to "count" also.... I usually refer to the whole column in the pivot cos the data ranges continually expand each month. Nice one Mudface, you solved a problem I didn't even realise I had

  4. #4
    New Member
    Join Date
    Feb 2002
    Location
    rvences
    Posts
    9
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Thanks for the info.!!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com