Fix, Unfix and Toggle Values

You can fix values to display the value rules grouped by the selected values.

Only the value rules that contain the selected or fixed value are displayed. The value with the corresponding dependent dimension (column) is displayed above the value rule table. The corresponding column is no longer displayed in the value control table.

When you create a new value rule, the fixed values are predefined. You only have to define the values that are not fixed.

Fix Values

Note

The Fix Value function is only active for value rules.

  1. In the value rule table, select the value (cell) of a value rule (row) that you want to fix.

    The row is highlighted in gray and the highlighted value is additionally framed in red.

  2. In the ribbon, click on View ► Fix Value ► Fix Value.

    The value is displayed above the value rule table with the corresponding dependent dimension (column). The corresponding column is no longer displayed in the value rule table.

  3. Repeat steps 1 to 3 to fix more values.
Note

If you fix a value column that exists multiple times then the other columns will also be fixed.

Unfix Values

  • In the ribbon, click on View ► Fix Value ► on the button:
  1. Unfix Value to unfix a selected value
  2. or

  3. Unfix All Values to unfix all of the selected values.

Alternative:  

  • Over the value rule table, click either:
  1. Unfix All Values to unfix all of the selected values.
  2. or

  3. Unfix Value to unfix a selected value

Toggle Values

  • Click above the value rule table on ▼ or in the selection field and select the relevant value to toggle the value.