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?
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?