6.2.6 Using a Field in a Condition

You can use table values as the test values in a filter condition. That is, you can define a filter condition that compares two values in the same row of the table.

To use a table field in a filter condition, follow these steps:

1. Open the Worksheet containing the table you want to filter.

2. Click the 'Condition' button on the title bar of the table you wish to filter. This opens the 'Condition' dialog box.

3. Open the edit field in either the 'Simple Condition' mode (click the 'More' button) or 'Advanced Condition' mode (click the pre-aggregate or post-aggregate 'Edit' button).

4. Make the desired selections in the left three menus.

5. Select 'Field' from the right-most menu. This enables a Combo Box on the right side of the condition.

 

6. In the Combo Box, select the table column containing the values to test.

The condition compares corresponding values in the selected columns (left-most menu and right-most menu), and preserves only rows where the condition is met.

See Also

Filtering, for details on specifying filtering conditions.

<< 6.2.5 Using a Parameter in a Condition © 1996-2013 InetSoft Technology Corporation (v11.5) 6.2.7 Using an Expression in a Condition >>