You can apply multiple filters for data in Query Designer. Filtering data enables you to isolate the data to be included in the report. AND and OR data filters are represented at the same level in the navigation panel. In addition, the word AND or OR precedes the data filter restriction. Grouping of data filter restrictions is not supported in this product. Following are some data restriction examples and their expected results:
This sample report displays the results of the data restriction. Notice that column B displays Margin % without #Missing values, and column L displays Profit, where the data is less than 2000 and greater than 3000.
Filtering by Comparing Data Values