The filters window allows you to manage the filters for the current data source.
To open the filters window:
| • | Click on the  button on the grid menubar |
| • | Right click on a column's caption in the grid or a legend item in the chart or the chart it self and select Manage... from the Filter submenu. |
| • | If a filter has already been set, the column in the grid to which the filter applies will have a icon. Clicking this icon invokes the filters dialog. |
Adding filters
To add a filter, click on the 
button or press the Insert key.
This will open the filter dialog:
In the first drop down list at the top, you can choose if you want to only show results meeting the specified condition or remove all results that meet the specified condition.
Next you need to select the column that you want to define the filter on. You can select a column from the list of columns.
The middle drop down list allows you to choose the type of filter you want to use. See the list of filter types below for a description of the types.
On the right hand side you can edit the value(s) to filter on. This can either be a whole or floating point number, depending on the underlying measure of the column you want to filter on.
Note: when defining the values for 'In' type filters, the various comparison values should be separated with semicolons (;).
If you want to add another filter click on again.
And/Or
By default, all conditions specified must be met, i.e. they are "Anded". If only one of the specified conditions needs to be met, you can change this clicking on the "And" and choose "Or" from the menu.
This mechanism can be used to create much more complex condition groups.
Order
The conditions are applied in the order they appear in the list. This means that a condition will always be applied to the result of the previous condition in the list (if present). You can change the order of the filters using the 
and 
buttons on the toolbar.
The following types of filters are supported:
is between |
The items whose value is between <value> and <value> |
is blank |
The items whose value is empty (null) |
in |
The items whose value is in a list of specified values |
= |
The items whose value is equal to <value> |
<> |
The items whose value is not equal to <value> |
> |
The items whose value is greater than <value> |
>= |
The items whose value for the given column is greater than or equal to <value> |
< |
The items whose value is less than <value> |
<= |
The items whose value is less than or equal to <value> |
is in the top # |
The <value> number of items with the highest values. See the TopCount function for more information. |
is in the top % |
The highest values for which the cumulative equals at least <value> percent of the total. See the TopPercent function for more information. |
is in the top S |
The highest values for which the cumulative equals at least <value>. |
is in the bottom # |
The <value> number of items with the lowest values. See the BottomCount function for more information. |
is in the bottom % |
The lowest values for which the cumulative equals at least <value> percent of the total. See the BottomPercent function for more information. |
is in the bottom S |
The lowest values for which the cumulative equals at least <value>. |
Editing filters
A filter can be edited by:
| 1. | selecting the filter and clicking the  button on the toolbar. |
| 2. | double clicking on the filter |
| 3. | selecting the filter and pressing the Enter key |
This will open the filter in the filter dialog window as shown above.
Removing filters
Individual conditions or condition groups can be deleted by selecting the condition or group and pressing the Delete key or clicking on the 
button in the toolbar.
To delete all the conditions at once, click the 
button on the toolbar.
Example
If you want to see all the data for a specific slice with a Internet Sales Amount greater than 5 million or the top 4 values for Internet Order Quantity,
the filter will look like this:
