Results 1 to 8 of 8
  1. #1
    Join Date
    Oct 2005
    Posts
    58

    Unanswered: Pivot Table Data Items

    Is there a way for the data in the "Drop Data Items Here" section of a Pivot Table to not be grouped or summed? I just want all the data, not a count or sum.

  2. #2
    Join Date
    Feb 2004
    Posts
    533
    After you drag your desired row field(s) and Data Fields to the Table Grid, right click on the field header and select "Field Options..." Change from 'Auto' option to 'None'

    For Row Totals and Grand Totals Right-click the Row Total Header and select "Table Options..." then you can uncheck Grand Totals. Optionally you can select the Table Options... Menu from the Pivot Table Toolbar drop menu.
    ~

    Bill

  3. #3
    Join Date
    Oct 2005
    Posts
    58
    I only have "Field Settings" and this doesn't work on the data field, only on the column fields.

  4. #4
    Join Date
    Feb 2004
    Posts
    533
    I think by Default the Pivot table at a minimum will have two columns. Column Name and Total column. You can remove the Sub Totals and Grand Totals but you will still have a column with the count of your data. You can always hide the totals column if you do not want to see the count. Maybe if you post an example, screen shot or attached file to show your problem?
    ~

    Bill

  5. #5
    Join Date
    Oct 2003
    Posts
    1,091
    Actually, it does not need Total Column. On the Pivottable toolbar choose Pivot table, then Table Options. There are three options in the upper left, one for column, the other for Rows, and one for Grand Totals. Uncheck all three.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  6. #6
    Join Date
    Feb 2004
    Posts
    533
    Shades, I checked this and see 'Grand totals for columns' and 'Grand totals for rows' on the Table Options settings. This allows selections for showing Grand Totals for the Table but does not disable count or sum of each row item. This was in Excel 2000, and 2003.

    If you have a Pivot with only row data, deselecting Grand totals for rows has no effect. Conversely a Pivot with only Columnar data will not be effect by unchecking Grand Totals for Columns.

    For data analysis purposes there's little need for data without a count or product of your key fields. It is useful for showing or obtaining a unique list of values.
    ~

    Bill

  7. #7
    Join Date
    Oct 2003
    Posts
    1,091
    Howdy, Bill. I think I misunderstood the issue.

    Too much time off this week!
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  8. #8
    Join Date
    Oct 2003
    Posts
    1,091
    If the need is for listing of unique values, it seems that Advanced Filter would be a better tool.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

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