Creating Comparison Filters

You can define filter criteria that compare the values in two different fields for the same task or resource. For example, to see whether a task started according to plan, you can filter for tasks in which the Actual Start date is less than or equal to the Baseline Start date.

To define a test that compares two fields, do the following:

1 Click the Field Name cell in the Filter Definition dialog box, click the down arrow, and then click the name of the field by which you want to filter.

2 Click the Test cell, click the down arrow, and then click the name of the test you want to use.

3 Click the Value(s) cell, click the down arrow, and then click the name of the field with which you want to compare the first field (see Figure 25-21).

A field name in the Value(s) cell is enclosed in square brackets [ ].

Figure 25-21. Create a filter that compares the value in one field against the value in another field.
Project Management Made Easy

Project Management Made Easy

What you need to know about… Project Management Made Easy! Project management consists of more than just a large building project and can encompass small projects as well. No matter what the size of your project, you need to have some sort of project management. How you manage your project has everything to do with its outcome.

Get My Free Ebook


Post a comment