Pivot Table - Duplicate values drop-down when I refresh data

V

Vicky

My summary data seems okay but the same text is showing up more than once in
the field drop-down. How do I stop this from happening? THanks!
 
M

Max

Usually data inconsistency. There's probably extra white spaces somewhere
within supposedly matching text which are not apparent/readily visible
(especially trailing white spaces). Use TRIM() to clean up the source col(s),
then refresh the pivot.
 
V

Vicky

Thanks, not sure that's it because sometimes they duplicate and other times
they dont. I will check it.

Any other thoughts?
 
M

Max

Vicky said:
Thanks, not sure that's it because sometimes they duplicate and other times
they dont. I will check it.
Click to expand...

Let us know the results of your check
Any other thoughts?
Click to expand...

One other possibility - some source numbers are text, some are real. Make a
decision. Convert all to either real numbers or all to text numbers.
 
Top