Basic Quantitative Filters

1. Open the Filter dialog box by dragging a measure to any shelf.
   
   
2. The Filter Field dialog box opens where you need to specify an aggregation. When finished, click Next.
   
   
3. The Filter dialog box opens. There are four types of quantitative filters: Range of Values, At Least, At Most, and Special. Each of these types of filters are described below:
   
   • Range of Values - Specify the minimum and maximum values of the range to include in the view. The values you specify are included in the range.
     
     
   • At Least - Include all values that are greater than or equal to a specified minimum value. This type of filter is useful when the data changes often so specifying an upper limit may not be possible.
     
     
   • At Most - Include all values that are less than or equal to a specified maximum value. This type of filter is useful when the data changes often so specifying a lower limit may not be possible.
     
     
   • Special - This special type of filter helps you filter on Null values. Include only Null values, Non-null values, or All Values.
     
     
4. When finished defining the filter click OK.