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 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.
In the Insertable Objects pane, on
the Source tab 
, click the
data item to add.
Drag the data item to the report as a nested column or nested row.
A black bar indicates where you can drop the data item.
Repeat steps 1 to 2 to add other nested columns or rows.
Tip: If you add more than one measure to a crosstab,
all measures appear as columns. You cannot have one measure appear
as a row and another as a column. To make all measures appear as
rows, swap columns and rows 
.
