Filtering Microdata and Drillthrough data

You can use filtering to locate records that conform to patterns such as equals, greater than, less than, contains, and starts with. Custom SQL queries are also supported.

To apply a filter to microdata or drillthrough data, do one of the following:

• Click Table options and select Filter.
• Select View menu > Table options > Filter.

The Filter Rows dialog appears.

Filters enable you to limit the data that appears on a microdata or drillthrough page.

• For example, you might only wish to see values that are greater than $100 and less than $500.

To create filters, first choose a field from the Field drop-down menu. Then choose an Operator and type a Value.

The following operators are provided:

• = Equals
• <> Does not equal
• < Is less than
• <= Is less than or equal to
• > Is greater than
• >= Is greater than or equal to
• IS NULL (is empty)
• IS NOT NULL (is not empty)
• Contains (For text fields only)
• Starts with (For text fields only)

Click OK to apply the filter, Cancel to return to the microdata or drillthrough page, or Clear to clear all the fields and start over.

• If you want to create another filter, choose whether you want both filters to be applied in combination (And) or separately (Or). Then create the new filter as above. You can enter a maximum of two filters on this page.