Exclude values on report when certain characteristic combinations occur
I have a query in which I would like to exlude certain characteristic combinations from being in the report body.
For example, when I run my query I would like to exclude values from my report when:
The PLANT is a certain value AND when the SALES GROUP is a certain value. (They both need to meet the criteria)
If the plant is 0007 and Sales Group is Unassigned then don't show the corresponding values on the report.
If the plant is 0007 and Sales Group is 030 then the values are displayed.
So that is the distinction.
I am not sure how to achieve this. Any assistance would be great!
Message was edited by: