I am building a report and need to build the following condition in the What filter group:
[Field 1] is not checked
[Field 2] is checked
[Field 3] is checked
In other words, it will first look for rows where [Field 1] is not checked and then further filter that dataset to only show rows where [Field 2] or [Field 3] is checked. However, it looks like I cannot mix AND and OR functions within the same group.
Any thoughts on how to accomplish this? Moreover, can this be added to the feature request list?