When selecting multiple fields for filtering, currently the system requires all data elements to be true to return results.
If I have Job Title (Sales Manager) and Group (Northwest) as fields to filter on, all users that are both in the group Northwest and have the title Sales Manager get filtered down to. What I would like is the option to indicate an "or" within the expression. I would like to select either those with the job title "Sales Manager" or those in the "Northwest" group.
My request is to include an "OR" check box for each field in the comparison, so that:
Field 1 (OR check box, checked)
Will result in all data matching Field 1 or Field 2.
Field 2 (OR check box, checked)
Will result in all data in (Field 1 and Field 2) or in Field 3.