Filter values using context

You can use one or more items to quickly focus your exploration on a particular view of the data. This technique is known as filtering using context.

For example, you have a crosstab showing products in the rows and revenue for different quarters in the columns. To change the context to Asia, you drag Asia from the source tree to the Context section of the overview area. The crosstab then shows only the values for Asia.

Changing context changes the values that appear. It does not limit or change the items in the rows or columns.

You can filter using multiple values in the context area, however, multiple filters are lost when you convert the exploration to formulas and start to use cell-based methods. Some context filters cannot be converted to formulas, such as multiple filters from the same dimension and filters from dimensions that are already displayed in the exploration.

Procedure

  1. In the source tree, select or search for one or more items to filter on.
  2. Drag the item that you want to filter on into the Context section of the overview area.

    A drop-down list box appears under Context.

  3. Click the item that you want.

    The crosstab shows the results only for the selected item.

    Tip: To change context, select a new item from the drop-down list under Context.
  4. If you want to use a custom set as a filter, drag the custom set from the Source Tree to the Context section of the overview area.
Parent topic: Limiting the Items in Your Analysis