Filtering with Multiple Fields

[bchoneycutt]

I need to create a filter will check against several columns where any single instance in any column would cause the entire row to be filtered out.

	Value 1	Value 2	Value 3	Value 4	Value 5
A	4	1	4	2	2
B	4	4	1	5	5
C	5	2	5	4	5

In example 1 would be the value that i want to be filtered, A and B would be filtered out, . This can be accomplished with individual filters but is clunky in the full workflow (10 Columns for the actual data) and since it is a flag and not an average I cannot pull data that way. I have also considered essentially concatenating all of the information from the columns with a formula into a new column and then filtering using that but I am not sure about that and it seems like that might not be the best solution long term, see the additional table for what I mean.  

	Value 1	Value 2	Value 3	Value 4	Value 5	Values
A	4	1	4	2	2	41422
B	4	4	1	5	5	44155
C	5	2	5	4	5	52545

Worst case is to create many filters but I would prefer a more condensed solution. 

[Luke_C · Accepted solution]

Hi @bchoneycutt 

Here's one way:

1. Transpose the data to review all fields at once
2. Filter to '1' to find the records that have 1's. 
3. Join back to the dataset and review the fall outs (these will be the records without the 1)