Adding a Cross Value Column

In DivePort 7.2(12) and later, you can add cross value columns to your measures portlet. You can create these columns using text or indicators.

On the page containing the measures portlet you want to edit:

  1. On the DivePort toolbar, click Edit.

    Edit mode is enabled.

  2. Right-click the measures portlet that you want to edit and in the context menu, select Edit.

    The Edit Measures Portlet Closeddialog box displays.

    The Edit Measures Portlet dialog box.

  3. In the Columns box, click Add.

    A Closedcontext menu displays.

    The Add context menu.

  4. Click Text columns.

    The Select values Closedpage displays in the dialog box.

    The Edit Measure Portlet dialog box Select values page.

  5. Double-click a value in the list.

    The Edit Measures Portlet Closeddialog box displays the column fields.

    The Edit Measures Portlet dialog box column fields.

  6. Optionally, enter the Title, Size, and Overflow.

  7. Next to Value, click the Column value icon.

    A Closedcontext menu displays.

    The Value context menu.

  8. In the context menu, click Cross value.

    The Column value icon becomes a Cross value icon and a secondary Dimension field Closeddisplays.

    The Edit Measures Portlet dialog box for the Cross value type column.

  9. Next to Dimension, click the field and from the Closedcontext menu select your second dimension value.

    Selecting the second dimension.

    NOTE: If you leave this blank, the column is considered to be a typical column value type rather than a cross value column.

  10. Optionally, enter a Date Range.

  11. If you want to color the value text, click the Edit this threshold icon An image of the Edit this column icon. to the right of the Any value item in the Colors box, and use the color picker to select a color.

  12. Click OK.

    The Closedcross column is added.

    Cross column added in the Edit Measures Portlet dialog box.

  13. Click OK.

    The Edit Measures Portlet dialog box closes, and the cross column displays in the Closedmeasures portlet.

    The added cross column in the measures portlet.

  14. If you want to have multiple cross dimensions displayed, repeat these steps to create multiple cross value columns.

  15. On the toolbar, click Save to save your changes and exit edit mode.

On the page containing the measures portlet you want to edit:

  1. On the DivePort toolbar, click Edit.

    Edit mode is enabled.

  2. Right-click the measures portlet that you want to edit and in the resulting context menu, select Edit.

    The Edit Measures Portlet Closeddialog box displays.

    The Edit Measures Portlet dialog box.

  3. In the Columns box, click Add.

    A Closedcontext menu displays.

    The Add context menu.

  4. Click Indicator column.

    The Select an indicator type Closedpage displays in the dialog box.

    The Edit Measures Portlet dialog box Select an indicator type page.

  5. Double-click your preferred indicator type.

    The Select a value Closedpage in the dialog box displays.

    The Edit Measures Portlet dialog box Select a value page appears.

  6. Double-click a value from the list.

    The Edit Measures Portlet Closeddialog box displays the column fields.

    The Edit Measures Portlet column fields.

  7. Optionally, enter the Title, Size, and Overflow.

  8. Next to Value, click the Column value icon.

    A Closedcontext menu displays.

    The Value context menu.

  9. In the context menu, click Cross value.

    The Column value icon becomes a Cross value icon and a secondary Dimension field Closeddisplays.

    The Cross column type fields in the Edit Measures Portlet dialog box.

  10. Next to Dimension, click the Closedfield and from the context menu select your second dimension value.

    The secondary Dimension field context menu.

    NOTE: If you leave this blank, the column is considered to be a typical column value type rather than a cross value column.

  11. Optionally, enter a Date Range. See here for more information on date ranges.

  12. If you want to color the value text, click the Edit this threshold icon An image of the Edit this column icon. to the right of the Any value item in the Colors box, and use the color picker to select a color.

  13. Optionally, add any other colors based on your selected Indicator. In this example, the Bar color.

  14. Click OK.

    The Closedcross column is added.

    The added cross column in the Edit Measures Portlet dialog box.

  15. Click OK.

    The Edit Measures Portlet dialog box closes, and the cross column displays in the Closedmeasures portlet.

    The measures portlet with the cross column with indicators.

  16. If you want to have multiple cross dimensions displayed, repeat these steps to create multiple cross value columns.

NOTES:

  • Each column can only have one cross dimension. Repeat these steps in order to have multiple cross dimensions displayed in your measures portlet.

  • Cross value columns are not allowed in a column group. If you try to add a cross column to a column group or edit a column within an already present group to become a cross column, the operation reverts and an alert displays.