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
Bookmarks