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

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!

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

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Vicky" wrote:
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!

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

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

Any other thoughts?

"Max" wrote:

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Vicky" wrote:
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!

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

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

Let us know the results of your check

Any other thoughts?

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.
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---