Label Filter - Does Not Contain

**popandfresh** · 04-19-2017, 09:50 AM

Hey Folks,

I have an issue with a pivot I have made.

Basically the data pulls from a system which is daily updated with new "counterparty" names which have date which I want to see. However, the problem I have is that there are certain counterparties I do not want to see so I have unfiltered them. However, this means that any new counterparties which are added to the system and pulls through into the pivot are not automatically added and need to be individually added.

Does anyone know a way around this? Only thing I can think of is to use instead of manually adding each one every day (can be 20+ a day) is to use the Label Filter - Does Not Contain - however this only works for one counterparty (as far as I can work out) and I have 15+ which do not need to be there.

Any help is appreciated.

Many Thanks
Chris

**dflak** · 04-19-2017, 04:05 PM

You can work around this with the source data.

First make an auxiliary table with the counter parties you don't want. I'll assume it's in an Excel Table called Table_Exclude and the header name is "Exclusions." I'll also assume your source data is in Table_Data and the field you want to check on is CounterParty. Change to suit your conditions.

Then make a helper column in the source data called "Include". In this column use the formula = ISNA(Match([@[CounterParty]],Table_Exclude[Exclusions],0))

This yields FALSE if the CounterParty is on the list you want to exclude and TRUE if it is not on the list. In other words, TRUE for those CounterParties you want to see. Use this new field as a report filter in the pivot table.

**popandfresh** · 04-20-2017, 06:09 AM

Excellent, it worked - thank you very much dflak!!!!

Label Filter - Does Not Contain

LinkBack

Thread Tools

Rate This Thread

Display

Label Filter - Does Not Contain

Re: Label Filter - Does Not Contain

Re: Label Filter - Does Not Contain

Thread Information

Users Browsing this Thread

Similar Threads

Filter Pivot Table Label via VBA

Combining a label filter with a (blank) filter

Pivot table w/ 3 row label layers, filter by the 3rd row label layer

Need to filter multiple criteria in Label Filter

Filter Pivot Table Row Label by Another Row Label

[SOLVED] Data Label Filter Out Zero in Bar Graph

filter a pivot table row label from vba,

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions