# Set modifiers with advanced searches

Advanced searches using wild cards and aggregations can be used to define sets.

Examples:

Examples and results

| Example | Result |
| --- | --- |
| sum( {$–1<Product = {“\*Internal\*”, “\*Domestic\*”}>} Sales ) | Returns the sales for current selection, excluding transactions pertaining to products with the string ‘Internal’ or ‘Domestic’ in the product name. |
| sum( {$<Customer = {“=Sum({1<Year = {2007}>} Sales ) > 1000000”}>} Sales ) | Returns the sales for current selection, but with a new selection in the 'Customer' field: only customers who during 2007 had a total sales of more than 1000000. |