How do I add a filter to a Pivot Table to filter out multiple values?
Using the Label > Does Not Contain filter I want to exclude "apples OR pears OR oranges".
What is the syntax for that?
How do I add a filter to a Pivot Table to filter out multiple values?
Using the Label > Does Not Contain filter I want to exclude "apples OR pears OR oranges".
What is the syntax for that?
Off the top of my head I suggest adding a helper column to the source data that identifies the terms to be filtered out. You may then be able to filter the pivot table based on the results of that column.
To see a more specific example please utilize the banner at the top of the page to upload a sample of your source data and resulting pivot table.
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks