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
