Nest Rows or Columns

You can nest items in a crosstab to compare information by using more than one item in a column or row. For example, a crosstab shows the sales by product line for the past fiscal year. You can add an item to further break down the sales by order method.

In the overview area , you can drag the boxes that represent the nested items to quickly change the nesting order.

Steps

1. In the source tree, click the item that you want to insert.

2. Drag the item to the location that you want in the rows or columns.

   A black bar indicates where you can drop the item.

   Tip: You can also nest rows and columns by right-clicking and using the shortcut menu.

Nest Items from the Same Dimension

You can expand and go down levels to nest items from a single dimension. Examples include nesting quarters in years, or nesting cities in countries.

The Expand command is available only when a dimension contains levels suitable for nesting.

Steps

1. Right-click the crosstab item that you want to nest and click Expand.

2. Click Down a level or Up a level to move through the different levels of the dimension.