Nest Members

When you insert members in your report, you may want to nest them in another row or column to make your report easier to use. You can nest members from different dimensions. You can also nest sets.

For example, in the following report, the quarters (Q1 to Q4) were selected from the Time dimension and nested only for the GO Americas member, which is from a different dimension.

a crosstab showing the year to date amount for all four quarters nested beside GO Americas but not for any other department — Figure 1. Crosstab showing the year to date amount for all four quarters nested beside GO Americas

When you filter out children from nested sets, the parent set still appears in your report. To avoid this, filter only the top level set and nest only the complete set of descendants at the desired levels.

Procedure

Click the Insertable objects icon

, click the Source tab

, drag the members to the work area.

A flashing black bar indicates where you can drop an item.