Select by Exception dialog box

Use the Select by Exception dialog box to select dimension values based on the data values in a particular measure or on the way those data values compare with data values in a second measure. For example, you might want to select all cities whose total dollar sales for a particular product exceeded $5,000,000 during the previous year. Or you might want to select all cities whose sales exceeded forecast by 10 percent.

Dialog box components

Selection Type box -- Contains the following options for the way newly selected values will affect the current selection:

Exception Type box -- Contains the following options for the type of exception criteria:

Exclude box -- Contains the following option for handling data values:

In hierarchy box -- Lists the hierarchies that are defined for the selected dimension. Select the hierarchy that you want to use. Select the hierarchy that you want to use or select NONE to include all dimension values.

At level(s) box -- Lists the levels in the selected hierarchy, if any. Select the levels that you want to include in your new selection. Use SHIFT+CLICK or CTRL+CLICK to select multiple levels.

For dimension box -- Identifies a single value for each of the other dimensions for the two measures. To change a selection, click on the adjacent Ellipsis button to get a list of all values in the dimension.

Script box -- Displays the criteria that will be added to the selection script if you choose OK.

Preview button -- Displays the Preview dialog box, which allows you to examine the change you are considering and lists the dimension values that will be selected if you adopt the change.

See also

About selecting Express data

Replacing or refining a selection

Selector toolbar