Make asymmetric selections on rows and columns

You can make asymmetric selections on rows and columns.

Suppose that you are looking at a view of sales, and you want to see the budget for the fourth quarter. Alongside the budget, you want to see actuals for the first, second, and third quarters. You can do this by making an asymmetric selection.

The following scenario uses the SData database.

Making an asymmetric selection in Planning Analytics Workspace

  1. In a new book, go to the SData database, expand Cubes > SalesCube > Views, and drag the Default view onto the sheet.
  2. Drag actvsbud from the Context area and drop it in front of month in the Column area.
  3. Click month and under Levels, select level001.

    You can now see the quarters.

    View showing quarters
  4. In the view, right-click the Variance heading, and click Hide.

    You can now see the Actual and Budget for the four quarters.

  5. To make an asymmetric selection, click Target selection in the toolbar or press F7.
  6. Under Budget, right-click 4 Quarter, and select Keep.
    Screenshot showing Target selecting enabled
    Note: To select multiple columns, click Ctrl while you click each member that you want to keep or hide in your asymmetric view. You can select only columns or rows that are visible in the view.
    You can now see your budget for 4 Quarter, and your actuals for 1 Quarter, 2 Quarter, 3 Quarter, and 4 Quarter.
    Asymmetric selection completed

Making an asymmetric selection in Planning Analytics Workspace Classic

  1. In a new book, go to the SData database, expand Cubes > SalesCube > Views, and drag the Default view onto the sheet.
  2. Drag the actvsbud tile from the Context and drop it in front of the Month tile on Columns so that it is nested:
    actvsbud and month tiles nested on columns
  3. Click the month tile and click Levels > level001.

    You can now see the quarters.

  4. Right-click the Variance heading, and click Hide.

    You can now see the Actual and Budget for the four quarters.

  5. Under the Actual heading, click 4 Quarter, then right-click and select Keep.
    Notice that the columns for 1 Quarter, 2 Quarter, and 3 Quarter are hidden for both Actual and Budget.
    view showing Actual and Budget

    You don't want this, so click Undo Undo.

  6. To make an asymmetric selection on columns, click the Targeted column selection icon Targeted column selection.
  7. Under the Budget heading, click 4 Quarter, then right-click and select Keep.
    Asymmetric column selection
    Note: To select multiple columns, click Ctrl while you click each member that you want to keep or hide in your asymmetric view. You can select only columns or rows that are visible in the view. You can click Clear to cancel your selections.
    You can now see your budget for 4 Quarter, and your actuals for 1 Quarter, 2 Quarter, 3 Quarter, and 4 Quarter.
    View showing budget for Q4, and actuals for q1, Q2, Q3, Q4