Filter = A and ( B or C )
For a sharepoint list, how does one get the above behavior?
For example, the default behavior would be Filter = A and B or C
Specifically, the desiresed filter is EmplyoeeActive = true AND ( Department = "Sales" OR Department = "Marketing" )
My current filter is returning any employee in sales or marketing, regardless of the the EmployeeActive being true.