Using the Exception tool

Use the Exception tool to select dimension values based on the values of a measure that uses the dimension. For example, you might select cities whose Sales values are greater than $1,000,000.

You can also use the Exception tool to base a selection on the comparison of two different measures. For example, you might select the products whose Sales were more than 5 percent above Forecast.

Note: The search for exception values is restricted to one dimension value for each of the other dimensions of the specified measure.

To select values using the Exception tool:
  1. In the Selector dialog box, choose the Exception tool from the Selector toolbar.

  2. Complete the Select by Exception dialog box.

  3. Choose OK.

See also

Selector toolbar