There are 2 levels of filtering available in the Advanced Data Grid:
•Simple, in-place filtering: allows you to specify simple filtering conditions based on any single criterion.
•Intermediate: allows you to specify simple filtering conditions based on any single criterion.
•Advanced: allows you to specify complex filtering conditions based on any combination of criteria.
Whichever filtering method you use, the currently applied filter will be displayed at the bottom of the Advanced Data Grid, as shown below.
Use the button to remove the displayed filter permanently. Alternatively, you can use the checkbox to disable the filter temporarily. To modify the displayed filter, use the Customize... button at the right of the filter zone.
Note that grouping often achieves the same results as some of the more complex filtering, and is more intuitive for most users.