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.

Figure 1. Crosstab showing the year to date amount for all four quarters nested beside GO Americas

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

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

From the Source tab

, drag the members to the work area.

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