Help

Using Condition function (filtering data)

Topic Labels: Data Workflow Design
479 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jendell_Duffner
4 - Data Explorer
4 - Data Explorer

I have a zip code field and only want 6 different zip codes from over 20 different ones I have in my data source.

I have successfully pulled those with the condition field use 'or'  but I also only want the ones that have an active customer  check marked.  when I place this as the 'or' field it then pulls all the other zip codes I do not want.  I am unable to place an 'and' condition successfully

I have resorted to grouping the active and inactive customers of each selected zip code but I want the inactive and active to be on separate reports (spreed sheet results) not one

What am I doing wrong with my condition codes?

 

In this view, show records
 
Where
Zip code
 
=
 
 
 
 
or
Zip code
 
=
 
 
 
 
or
Zip code
 
=
 
 
 
 
or
Zip code
 
=
 
 
 
 
or
Zip code
 
=
 
 
 
 
or
Zip code
 
=
 
 
 
 
or
Zip code
 
=
 
 
 
 
or
Zip code
 
=
 
 
 
 
 
 
 
0 Replies 0