Hi everyone.
I feel that there is potentially a straightforward answer to this question but I'm having trouble retrieving the results I'm looking for out of a query. Basically, I want to bring back a list which has a True value for a field.. but it also needs to be False for another string in the same field.
For example, lets just use the fields 'Customer' & 'Field 1' for the sake of this example.
For 'Customer', I want to bring back a certain string in 'Field 1' but they can't have a certain other string in 'Field 1' otherwise I don't want that customer to be brought back in the results. The issue I'm currently having is that the query will bring back & only display what I set in 'Field 1' but if I try and set a 'Not in list' for a different string in 'Field 1' it might still exist for the customer in the database regardless, it just won't be displayed in the report.
I've tried messing around with combined queries and nested filters but haven't quite figured it out. Could someone put me on the right lines? Apologies if I've made it sound confusing! I'm on WEBI 4.1.
Many thanks,
Nick