When you filter a data source table, you use a SQL WHERE clause to indicate specific characteristics for the data you want to view. You can access any data that is in the source table. For example, suppose that you are viewing the DEMOG table in the source database, and you want to look at only cases for females. If Gender is stored in the DEMOG table, you can filter by Gender.
1. On the Data Sources page displaying the data source table, click Filter.
The Specify Filter page appears.
2. In the SQL WHERE clause text box, type a SQL WHERE clause. You can refer to any of the columns listed on the Table Viewing Options page, regardless of whether or not you included them in the displayed table.
3. Click Apply Filter. To remove the filter, click Clear.
The filtered data source table appears.