Adding a Filter (Select from a list)

Follow the instructions below to add a filter in which values are selected from a list:

1. In the toolbar, click (Filters).

A Filters panel appears above the report.

2. Click and drag a field from the right pane into the Filters area.

The Filters dialog box opens.

3. Drag the SW Is Licensable? field into the Filters pane. A Filter on Is Licensable? dialogue box will appear. Click Select from list.

You can immediately designate all the values in the list to be included in or excluded from the filter by clicking Includes or Excludes.

Filtering on “SW Is Licensable?”.

A list of values appear in the left pane of the dialog box.

4. Select one or more values from the list box on the left; click (Add Selected) to move the value to the list box on the right.

Note:If necessary, you can designate the values in the right pane to be included or excluded by selecting Included or Excluded from the list next to Currently.

If the list of filter values is long, you may not see the value(s) you want to include or exclude from the filter. In the Choose value from list text box, enter the initial letters of the value you are searching for and click Find. Your entries are case-sensitive.

You can remove values from the list by clicking (Remove Selected). To add or remove all filter values click , (Add All), (Remove all), respectively.

5. Click OK to save your filter.

The report display updates when the filter is added. The filter appears in the Filter box and an icon displays next to the field name under the Data tab. Also, the number of filters added to the report appears next to the filter icon in the toolbar.

You can edit the filter by clicking (Edit). You can delete the filter by clicking (Delete).