Pivot Table & Slicers

I'm fairly new to pivot tables & slicers but I like what I see thus far.

The slicer I'm concerned with is the "GAP" slicer. If you look at the #'s you'll see some #'s listed twice. For example, -2, 1, 2, -3 are all listed twice. I don't know why this is happening.

The purpose of this # in the GAP slicer is to only show accounts that have that GAP listed from the "Table Data Base" which is where my table is. For example, when I click -2 I see many accounts that have a gap of -2 listed. Then I click the other -2 & see a total different list. But both lists are correct in that the account has a -2 gap. Just no idea why it's showing up twice.

There might be a better way of doing this. Ultimately the ONLY important data in the "table data base" that this # means anything is the account name. But the only logical way I could find to import it in was by V Look up from the "tap count" data base. But the problem with that is it enters the # every time it matches with the customer #.

EDIT: I can only provide a screen shot. My file is too big. 1.3 MB. Site has a 1 MB limit. I can always remove some of the data but before I do that see if a screen shot can help with the answer.

Hey Statz,

I'd bet you have a space or two (pun intended) in your "-2" data. If the "-2" is text and had a space before, after or in-between the letters it would show up multiple times in your Slicer tool.

Sort your data by that "Gap" column and look at the top and bottom to see which are different but look the same.

Normally problems like this are from people who like to put a space before or after text. If you use the Trim() function on a whole column and then paste values only on top of the column, it will take care of many of these data entry problems. If you have values then converting the text to numbers is what I'd do to insure you remove those text cells that you think are numbers. I've seen people who use the letter "oh" instead of zero because it looks the same to them. These are the same guys who use lower case L instead of one. The computer knows the difference.