Create an advanced slicer filter

To use a calculation or expression to define a context filter, create a slicer member set using the query explorer. A slicer member set is an expression that returns a set of members from the same dimension. For example, you can define a slicer member set that filters for the top five products with the greatest revenue.

Procedure

  1. Click the Queries icon Queries icon, and click the query for which you want to add a slicer.
  2. Click the Toolbox icon toolbox tab and drag Slicer member set to the Slicer pane.
  3. Drag the members to the Expression Definition box.

    You must join the members in the expression by using the set function. For example, the following expression contains the Fax and Telephone members from the Order Method dimension:

    set ([Fax],[Telephone])

  4. To add members from another dimension, repeat step 2 to create a separate slicer member set.