Forum Discussion
Pivot table label filter not working in filters area
Dear all I do not get the following behavior of pivot table (using Office 365): When I want to filter a field to not end with some specific text, I have to pull it into Rows or Columns area to...
In general that how it works. However, in report filter you may use Search bar for more exact filtering.
For such example
you may use *e in search bar to filter on all words ending by e
result is
Thx for your reply, the search only works for something I want to see, not for items I don't want to see.
For item you don't want to see, back to previous sample ended by e, you use use *e in search bar, uncheck selection and check Add current selection to filter. With that items ended by e will be excluded.