Advanced searches using wild cards and aggregations can be used to define sets.
Examples:
| 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. |
