You can use expressions to search and select in filter panes and current selection items.
An expression search always begins with an equals sign (=). The expression is evaluated for each field value in the search field. All values for which the search expression returns a non-zero value are selected.
In a filter pane with Sales values, you can use a search such as: =Sum(Sales) > 1000000 to find values larger than 1,000,000. This is a simple search and you could get the same result by using the numeric search: >1000000. Often, an expression search is the only choice. For example, if you want to search for values in associated fields, you have to use an expression search.
Example:
Let us assume that you have a filter pane for sales representatives. You can then use an expression search for the sales representatives who have sales larger than, for example, 5,000,000. The search string is similar to the previous one: =Sum(Sales) > 50000000. Because the sales values are associated with the sales representatives, you can perform the search in the Sales Rep filter pane.
