Results 1 to 3 of 3

Values appear twice in PivotTable row labels

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-26-2009
    Location
    Austin, TX
    MS-Off Ver
    Excel 2016
    Posts
    241

    Values appear twice in PivotTable row labels

    Hi Everyone,

    I have a PivotTable that is summarizing a data table.

    In the configuration panel, I've dragged one column ("C92") to the "Row Labels" area.

    Likewise, I've dragged the same column to the "Values" area, where it defaults to "Count of C93". So far, so good.

    I should mention that my values in column C92 are the whole numbers 0-7 and the string "NA".

    But in the output chart, each of these values is listed twice! And each count of each value is different!

    I'm attaching a cut-down version of the spreadsheet that shows this behavior.

    Can anyone clue me in as to why this is happening? And how I can prevent it?

    Cheers,

    Jay
    Attached Files Attached Files
    Last edited by JayUSA; 02-01-2010 at 07:15 PM.

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