Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Oct 2003
    Posts
    33
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Table (2007)

    is there a way to change the default setting of the VALUE field from COUNT to SUM?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Pivot Table (2007)

    Excel will suggest SUM if the data field is numeric, and COUNT otherwise i.e. if the data field contains text, TRUE/FALSE, dates or a mixture of data types. You can't change these defaults.

    <table border=1><td>Function</td><td>Description</td><td>Sum</td><td>The sum of the values.
    This is the default function for numeric data.</td><td>Count</td><td>The number of data values.
    The Count summary function works the same as the COUNTA worksheet function.
    Count is the default function for data other than numbers.</td></table>
    (From: Subtotal and total fields in a PivotTable report)

Posting Permissions

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