Pivot Table Filter tricks for 10,000+ uniques?

[indygo]

hi gents,

I'm sure you all came across this issue with Pivot Table when it tells you that "Not all items are showing" simply because there are too many unique items in the filter.
My problem is this, let's say I have 30,000 unique tags in the filter and I want to exclude just one which is shorter than others. So let's say tags are in this format:

3333_99123447
2223_12349333
1234

Now, if I have one unique tag which I want to exclude which is shorter, and when I type it it also selects others that CONTAIN that number, in this example its 1234
So in that example all 3 tags would be highlighted by the filter instead of excluding just the last one.

Are there any tricks to exclude just one? I can't force filter to display just that one "1234" no matter how I type it even with the star in front of it - it includes other tags too!
It seems that pivot filter has this inverted logic just to include instead of excluding items...

any ideas?

 

[mrshl9898]

The answer is in your question. Type the 6 characters "1234"

 

[indygo]

thanks and you're not wrong but now that I found that unique "1234" I'm only including data from that 1234 and I want to exclude it from the data. Now 1234 is the only selection in that filter.

 

[RoryA]

Use the custom text filter 'does not equal' and 1234 as the value.