Add Nested Categories for More Detail

In a crosstab report, nested categories are groups of information that appear above or below each other in the columns, or beside each other in the rows.

In both Reporter and Explorer reports, you can nest categories from the same dimension, from different dimensions, or from categories and measures together. For example, you can create a report that shows the revenue and product cost for each product line over several months.

While adding nested categories can reveal important information about your business on a single page, too many nested categories can make report results a challenge to understand. Limiting the focus to the margin range performance for each location shows the trends most clearly.

Try This

To remove the Locations categories from the layers and add them as a nested level to the rows:

Steps

1. Right-click the layer bar, and click Delete All Layers.

2. Click the Crosstab button .

3. In the dimension viewer, click the expand icon beside Locations.

4. Ctrl+click to select Locations, Americas, Central Europe, Asia Pacific, Northern Europe, and Southern Europe.

5. Drag the categories and drop them to the right of the first column.

   Note: A thick black line appears when you reach the long bar drop zone, as shown below.

   

6. Select and delete the Under 20% and 20% - 65%categories.

   Note: You can only delete categories in a Reporter report.

7. Move the Over 65% category to the right of the Locations, Americas, Central Europe, Asia Pacific, Northern Europe, and Southern Europe column.

   

   Notice that Locations and the Over 65% margin range are nested together, producing groups of information.

8. Click the Multiline button .