Switching Pivot Facts

Control the visibility of pivot fact columns. Dashboard developers specify pivot fact columns to be visible or hidden when a dashboard is opened. End users have the option to hide or reveal additional fact columns.

Depending upon how the dashboard was configured, all fact columns available for a pivot can be displayed in a list or drop-down list.

The feature does not affect charts.

*  To switch pivot facts:

  1. In Interactive Reporting Studio, on the dashboard top panel, click Switch Pivot Facts button.

    • If configured, a Switch Pivot Fact list is displayed with a list of fact columns

    • If a Switch Pivot Fact list is not configured, a drop-down list of fact columns is displayed

      Hidden fact columns are denoted by [ ]. Visible fact columns are denoted by [ = ].

  2. Select a fact column from the list.

    The column is displayed or hidden accordingly.

  3. Click Switch Pivot Facts button again, to hide the drop-down list.

    See Using the Pivot Fact Properties Frame.

Note:

If a pivot is configured with the Switch Pivot Facts feature, items on the y-axis (fact) cannot be changed by Quick Slice.

Switch Pivot Facts can be used in conjunction with the Drill and Slice component that is available with Dashboard Studio. If you drill down into data and subsequently create a greater number of displayed fact columns in a pivot, Switch Pivot Facts can provide a snapshot of the most pertinent facts, by hiding the less apt information and revealing the more important facts in selected pivot fact columns. See Using a Runtime Release of the Drill and Slice Component.