With advanced filter you can filter data based on any rule. This is a simplified version of database quering without you having to write any SQL query. You will just use UI dropdown and filter data based on your conditions.
I want to filter all products under Category “Desktops“
I want to filter products that have quantity less than 10
I want to filter products that have quantity greater than or equal to 100, and only category belongs to desktops, and manufacturer belongs to Apple or Sony