Keep Only

Focuses one member by allowing you to clear all other dimension member selections except the selected member from the results set. Non-kept members are not available on the Member Selection dialog box.

  To keep specific set members:

  1. Select one member or a range of members.

    Use Ctrl + click to keep nonadjacent cells.

  2. Select a dimension label and select Keep Only on the shortcut menu.

    Only the selected members are shown.