Use and when you want both expressions to be true in order for the filter to be true. Use or when either expression can be true for the filter to be true. Or, if you are filtering on a measure, the name can consist of the acceptable measure names. See the Reference Guide to Dimensions and Measures for a comprehensive list of names that you can use in a filter. See Understanding Filters for a list of the measure names.
Different values are appropriate for different names.
In general, a value is either a date, an integer, a string, or a relative filter value. Carriage returns are ignored within filter expressions. You can add the following wildcard values to a filter. Matches any single alphabetic character. Matches any character not in the brackets.