How do I create a subquery?

Click Edit on the Data Access tab > Data Providers sub-tab to display the Web Intelligence Query Panel.

screen shot

To choose the target of your subquery, click a data element from the element list or from Result Objects pane to highlight it.

screen shot

Click the Add a subquery icon to add a subquery object to the Query Filters pane.

(Note: This icon is not available if your Web Intelligence > Modify preference is set to "HTML").

screen shot

Drag the data element from the right-hand box in the subquery object to remove it.

screen shot

Drag a new data element from the data element list to the right-hand box in the subquery object.

screen shot

Add criteria to the subquery object as needed.

screen shot