If you want to filter the DataPilot table with complex
conditions, use the data source filter.
To use the data source filter, perform the following steps:
- Click , the Filter window
displays.
- Select one of the logical operators AND / OR for the operator.
- Specify the field names from the current table to set them
in the argument for field names.
- Specifies the comparative operators through which the entries
in the Field name and Value fields
can be linked for the condition.
- Specify a value to filter the field.
- Click OK. Only the rows that meet your criteria are displayed.