How to create multiple conditions

You use a multiple condition to display only data that matches multiple condition statements that you cannot display using a single condition. For example, to display data for the year 2000 that also relates to the Eastern region.

To create a multiple condition:

1. Choose Tools | Conditions to display the "Edit Worksheet dialog: Select Items tab: Conditions tab".

   
   Description of the illustration cond10.gif
   
   

2. Click New and select New Condition from the drop down list to display the "New Condition dialog".

   
   Description of the illustration cond7.gif
   
   

3. Create a single condition (for more information, see "How to create single conditions").

4. Click Advanced.

   Discoverer adds Insert buttons for New Item, And, and Or. You use these buttons to create the advanced condition.

   
   Description of the illustration condex2.gif
   
   

5. To build a multiple condition, do one or more of the following:

   • Click New Item in the Insert box to insert a new condition statement line to the condition.

     By default, the new item is grouped with a logical AND, which means that data must match all condition statements contained within the AND group.

   • Click And in the Insert box to insert a new condition statement line to the condition. Using AND narrows a search to display only items that match all criteria.

   • Click Or in the Insert box to insert a new condition statement line to the condition. Using OR widens a search to display items that match any of the criteria.

     Hint: To change the way that condition statements are grouped, click the buttons in the Group column to display a drop down list of options (e.g. AND, OR, NOT AND, or NOT OR).

6. When you have finished, click OK to save the multiple condition and close the dialog.

   The new condition appears in the Conditions dialog and is turned on.

7. Click OK to close the Conditions dialog and return to the worksheet.

Discoverer filters the worksheet to display only data that matches the condition. Data that does not match the condition is not displayed.

Notes

• You can also create a new condition in the following ways:

  • If the Available Items pane is displayed, select the New Condition option on the Available Items toolbar (for more information, see "Available Items pane").

  • If the Available Items pane is displayed, right-click in the Conditions tab and select New Condition.

• To create a multiple condition, you might also add condition statements to an existing single condition.