Advanced searches using wild cards and aggregations can be used to define sets.
Examples and results:
| Examples | Results |
|---|---|
| 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. |
Did this page help you?
If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!