Check members

In standard grids that compare members, you can selectively checkmark any dimension members or key members to view their subtotals, drill down on them, show the checked members in graphs, and more.

To checkmark members individually

Click the box(es) beside the member(s).

 

To checkmark a range (i.e., block) of members

 

  1. Click on the top row of the desired range to select it. If you do not select a row, the grid will use the first row by default.

  2. Press Shift as you click on the bottom row of the desired range.

Tips:

If you prefer, you can select the bottom row first and then press Shift as you click on the top row.

This method also works for unchecking a range.

 This method is limited to the current page of data and does not work when infinite scrolling is on.

 

After checking members:

 

 

You can view subtotals by clicking the subtotal button at the bottom of the widget.

You can drill down on the checked members by clicking the Downlevel button and selecting Drill into Checked.