As discussed previously in the chapter, tables are a central building block of Microsoft Project. They determine which columns of fields are displayed for tasks or resources. Filters are another major building block; they determine which tasks or resources are displayed, depending on criteria that you provide.
All the views except the Relationship Diagram view can have filters applied. Any view that can accept a filter can have one defined as part of the view: When the view is selected, the filter is automatically applied. All the standard views initially have the All Tasks or All Resources filters designated as part of the view definitions.
NOTE
Any view in the bottom pane of a combination view cannot have any filters applied. The bottom pane is already being filtered by virtue of being the bottom pane, which is always controlled by what is selected in the top pane.
A filter helps you identify and display only the tasks or resources (depending on the view) that match one or more criteria. All other tasks or resources are temporarily hidden. If a filter is applied as a highlight filter, all tasks or resources are displayed, but those that are selected by the filter are displayed with highlight formatting features such as a different color, bold, italic, and underline, which you can define by choosing Format, Text Styles. Any filter can be applied as a highlight filter or a display-only filter. You define the criteria for a filter by specifying one or more field values that must be matched for a task or resource to be selected by the filter.
Filters have the following key characteristics:
A calculated filter compares two or more values in the Project database, or it compares a database field to a value you enter manually in the filter definition. For example, a filter can compare the baseline cost to the total cost for a task, or it can compare the total cost to some value (such as $5,000) that you specify.
Interactive filters prompt the user for a comparison value (or values) when the filter is applied. For example, the Using Resource filter asks the user to choose a resource name from a drop-down list.
All filters can be applied to highlight tasks that meet the criteria, instead of hide those that don’t match.
→ To learn more about highlighting specific groups of tasks or resources, see “Formatting Text Displays for Categories of Tasks and Resources,” p. 728.
NOTE
Each filter on the Project, Filtered For menu that contains an ellipsis (…) is an interactive filter.
TIP
You can apply an existing filter by using the Filter list box on the Formatting toolbar. |
A filter can do much more powerful work than perform one simple test. Compound filters incorporate multiple tests against the tasks to perform more complex filtering. The following tests can be included in filters:
Inclusive filters use the And condition to require that all test conditions are met.
Exclusive filters use an Or test to choose tasks that meet at least one test condition.
You can evaluate groups of And/Or tests independently and combine the results with other groups of tests by using an And or Or condition between groups of tests. For example, the Using Resource in Date Range filter first finds all tasks that have a certain resource assigned, and then it tests both the start and finish dates for those tasks to find tasks that finish within a range of dates.
To apply a filter to a view, you can choose Project, Filtered For or use the Filter tool on the Formatting toolbar. If the filter you want is on the Project, Filtered For menu (shown in Figure 19.26), you can select the filter name, and it will be applied immediately. If the filter is not on the Project, Filtered For cascading menu, you can choose More Filters and then select the filter name from the complete list of filters in the More Filters dialog box list (see Figure 19.27). You click the Apply button to apply the filter so that only tasks or resources that satisfy the filter appear. If you want to apply the filter as a highlight filter (so that filtered items are highlighted and all other items remain displayed), click the Highlight button instead of Apply.
NOTE
You can apply filters as highlight filters by holding down the Shift key as you choose Project, Filtered For and select the filter name.
Another way to apply a filter to the current view is by selecting the filter name from the Filter tool on the Formatting toolbar (see Figure 19.28). When you select the filter name from the list, the filter is applied immediately. You cannot apply the filter as a highlight filter when you use the Filter tool. |
When you apply an interactive filter, a dialog box appears, in which you must supply the values to be used for testing the tasks or resources. For example, Figure 19.29 shows the Using Resource filter dialog box. This filter selects all tasks that are assigned to the resource that you choose from the entry list.
When you apply a filter, all tasks or resources that satisfy the filter criteria at that moment are selected. If you change a value in a field, you might change how this value satisfies the filter criteria. The task or resource continues to be displayed or highlighted, though, because the filter criteria are evaluated only at the moment the filter is applied. You need to apply the filter again to see the effects of changes in the project.
NOTE
You can reapply the filter by pressing Ctrl+F3. You can set a filter back to the default All Tasks or All Resources by pressing F3.
It is important to note that a filter is applied to the view that is currently being displayed and does not affect the list of tasks or resources on other views. For example, if you filter in the Gantt Chart view to see only critical tasks (by applying the Critical filter), and then you switch to the Tracking Gantt view, all tasks are displayed on the Tracking Gantt view, not just the critical tasks. An applied filter stays in effect on the view you applied it to until you remove it. After you have finished using a filtered view, you can remove the filter by selecting the All Tasks filter or the All Resources filter.
Not every view can be filtered, and there are other limitations to using filters. The following points summarize these limitations:
You can apply only task filters to task views and only resource filters to resource views.
You cannot apply a filter to a bottom pane view. The reason is that the bottom pane view is already filtered: It displays only the tasks or resources that are associated with the item or items selected in the top pane.
The Relationship Diagram view cannot be filtered, but the standard filters are available for all other views.
You cannot apply a highlight filter to a form. Using a filter as a highlight makes sense only for the views that display lists because the purpose of a highlight is to make selected items stand out from the rest. Thus, only the views that contain tables can accept highlight filters.
Each filter considers the entire set of tasks or resources for selection. You cannot use successive filters to progressively narrow the set of selected tasks or resources. For example, if you filter the task list to show milestones, and then you apply the Critical filter, you will see all critical tasks displayed, not just critical milestones. You must either create a filter, edit an existing one, or use the AutoFilter option to use more than one criterion at a time.
→ To learn how to create your own filters, see “Creating Custom Filters,” p. 860.
The filters that are supplied with Microsoft Project provide standard selection criteria that are useful in many situations that you will encounter. You might never need to create your own filters. Tables 19.3 and 19.4 describe the standard task filters and resource filters, respectively.
Table 19.4 lists the filters that can be applied to task views. An asterisk (*) indicates that the filter is not found on the standard Project, Filtered For menu but is found instead on the More Filters menu. All filters are listed in the Filter tool on the Formatting toolbar as well. A filter name that is followed by an ellipsis (…) is an interactive filter. |
Table 19.5 lists the filters that are available for resource views. Again, an asterisk (*) marks filters that are not found on the standard Project, Filtered For menu but that are found instead on the More Filters menu.
When it is enabled, the AutoFilter places a drop-down arrow at the top of each table column and creates a list of unique values in each column (see Figure 19.30). To filter that column, you choose an option from the drop-down menu. The column heading turns blue, to indicate that the column is filtered. You can apply a filter in this way to more than one column in order to perform successive filters. For example, in Figure 19.30 filters have been used to display only the tasks which are assigned to John Melville that are scheduled to last longer than one week.
Project includes special options in some lists, depending on the field type. For example, the Duration field has AutoFilter options for values one week or less, more than one week, and so on. Date fields have options for ranges as well—such as this week, this month, and next month (see Figure 19.31).
Each of the drop-down menus also has a custom option that allows you to create and save a filter with more than one condition, using either an And or an Or condition (see Figure 19.31).
→ For additional information on creating your own specialized filters, see “Creating Custom Filters,” p. 860.
NOTE
The keystrokes that reapply the filter (Ctrl+F3) and set a filter back to the default All Tasks or All Resources (F3) also work with AutoFilter.