Create a Single-Edge Crosstab

Create a single-edge crosstab report to show data in a list-like form. For example, to show the quantity of products sold for each year and for each order method, you could create a crosstab with Order Year and Order Method as rows and Quantity as the measure.

Steps

1. From the File menu, click New.

2. Click Crosstab and click OK.

3. In the Insertable Objects pane, on the Source tab , drag data items to the Rows or Columns drop zone.

   A black bar indicates where you can drop the data item.

4. Repeat step 3 to insert additional data items:

   • If you dragged the data item in step 3 to the Rows drop zone, drag the additional items above or below the first item.

   • If you dragged the data item in step 3 to the Columns drop zone, drag the additional items to the left or right of the first item.

5. To add measures to the crosstab, drag the measures to the Measures drop zone.

When you run the report, a crosstab is produced that has only one edge.