In the C1OlapPanel control or the C1OlapPanel area of the C1OlapPage control, you can filter the data in a field from the Drag fields between areas below section of the panel at run time. Each field has two filters: the value filter, which allows you to check specific values in a list, and the range filter, which allows you to specify one or two criteria. The two filters are independent, and values must pass both filters in order to be included in the OLAP table.
Using the Value Filter
Once you have selected the fields to appear in the table, you can specify a range filter by clicking the Text Filter or Numeric Filter button at the bottom of the window.
Note: If the field you are filtering contains numeric data, Numeric Filter appears instead of Text Filter. |
Using the Range Filter
Clear Filter |
Clears all filter settings. |
Equals |
Opens the Custom Filter dialog box so you can create a filter where items equal to the specified value are shown. |
Does Not Equal |
Opens the Custom Filter dialog box so you can create a filter where items that are not the same as the specified value are shown. |
Begins With |
Opens the Custom Filter dialog box so you can create a filter where items that begin with the specified value are shown. |
Ends With |
Opens the Custom Filter dialog box so you can create a filter where items that end with the specified value are shown. |
Contains |
Opens the Custom Filter dialog box so you can create a filter where items that contain the specified value are shown. |
Does Not Contain |
Opens the Custom Filter dialog box so you can create a filter where items that do not contain the specified value are shown. |
Custom Filter |
Opens the Custom Filter dialog box so you can create a filter with your own conditions. |