Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Pivot table label filter not working in filters area

Copper Contributor

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 be able to use label filter. But this just adds another "level" to my data, which is not needed. 

When I pull the field into the Filters area it just gives me the possibility to manually (multi) select (in this case deselect) the items.

Do I miss any option here, or is it "like it is"?

BR
Dirk

3 Replies

@dirk_aptiv 

In general that how it works. However, in report filter you may use Search bar for more exact filtering. 

For such example

image.png

you may use *e in search bar to filter on all words ending by e

image.png

result is

image.png

Thx for your reply, the search only works for something I want to see, not for items I don't want to see.

@dirk_aptiv 

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.