6.2.2 Defining Advanced Conditions

To specify conditions on both pre-aggregate and post-aggregate data, as well as group rankings, use the 'Advanced Conditions' dialog box. Advanced conditions can additionally be joined using both 'AND' and 'OR' operations. If you only need pre-aggregate conditions and 'AND' operations, you can use simple conditions instead. See Defining Simple Conditions for more information.

To define advanced conditions, follow these steps:

1. Click the 'Condition' button on the title bar of a Data Table. This opens the 'Condition' dialog box.

2. Select the 'Advanced Conditions' check box.

The 'Advanced Conditions' check box can be used to toggle between simple and advanced conditions. However, when switch­ing from the 'Advanced conditions' mode to the 'Simple Condi­tions' mode, if an advanced condition cannot be mapped to a simple condition, it will be permanently removed from the list of conditions.

 

3. Define a condition on pre-aggregate data, post-aggregate data, or ranking by clicking on the corresponding 'Edit' button. See Pre-aggregate, Post-aggregate, and Ranking Conditions below.

If the condition you specify references attributes that do not already exist in the table, these attributes are automatically added to the table as invisible columns.

<< 6.2.1 Defining Simple Conditions © 1996-2013 InetSoft Technology Corporation (v11.5) Pre-aggregate, Post-aggregate, and Ranking Conditions >>