Create a Nested Crosstab

Nest data in a crosstab report to compare information by using more than one data item in a column or row. For example, a report shows the number of sales by product line for the past fiscal year. You decide to add a data item to further break down the number of sales by quarter.

When nesting columns in a crosstab report, there are four distinct drop zones where you can insert a new data item. The drop zone you choose will define the relationship between the data item and the column.

The following relationships are created when you insert a data item as a row:

• Inserting a data item to the left or right of a column creates a parent-child relationship between them.

  When you insert a data item to the left of a column, the data item becomes a parent to the column. When you insert a data item to the right of a column, the data item becomes a child of the column.

• Inserting a data item above or below a column creates a union relationship between them.

The following relationships are created when you insert a data item as a column:

• Inserting a data item to the left or right of a column creates a union relationship between them.
• Inserting a data item above or below a column creates a parent-child relationship between them.

When you insert a data item above a column, the data item becomes a parent to the column. When you insert a data item below a column, the data item becomes a child of the column.

For example, you have a crosstab with Product line as rows and Quantity and Revenue as nested rows. For columns, you have Order method with Country or Region as a nested column. In this crosstab,

• Product line is a parent to Quantity and Revenue.
• Quantity and Revenue are peers.
• Order method is a parent to Country or Region.