Replace Nested Categories

You can replace a nested level with the parent category or all the child categories. For example, you nest Years with the next level down, Quarters. Then you want the report to show Months instead of Quarters. You can replace the nested level with Months.

Steps

1. In the dimension viewer, locate the category you want to show as the new nested level.
2. Right-click the category, and then click Nest Rows or Nest Columns.

This category is now the nested level in the display.

Tips

• You can also click the new category you want to nest in the dimension viewer, and then drag it to the row nest level area or the column nest level area of the parent category.

As you drag the category over the nest level area, the area becomes highlighted.

Note: The row nest level area is located in the far right of the row heading area. The column nest level area is located at the bottom of the column heading area.

• To nest a new category from the dimension line, click the dimension, locate the category you want to nest, and then drag it to the row nest level area or the column nest level area.
• You can replace a nested category by dragging and dropping another nested category in your crosstab .