Example - Create a Discontinuous Crosstab

You are a report author at The Great Outdoors Company, which sells sporting equipment. You are requested to create a report showing sales for each product line by quarter and by order method. Since the report will have columns with data from different dimensions, you create a discontinuous crosstab report. Discontinuous crosstabs are also known as disconnected or disjoint crosstabs or crosstabs with unrelated columns.

Steps

1. Open Report Studio with the GO Data Warehouse (query) package.

2. In the Welcome dialog box, click Create a new report or template.

3. In the New dialog box, click Crosstab and click OK.

4. In the Insertable Objects pane, on the Source tab :

   • Expand Sales and Marketing (query) and Sales (query).

   • Expand Product and drag Product line to the Rows area.

   • Expand Order method and drag Order method to the Columns area.

   • Expand Sales fact and drag Revenue to the Measures area.

5. Pause the pointer over the query explorer button  and click Query1.

6. On the Toolbox tab , drag Data Item to the Data Items pane.

   The Data Item Expression dialog box appears.

7. In the Expression Definition box, type the following and click OK:

   [Employee summary (query)].[Employee by region].[Region]

8. In the Properties pane, set the Name property to Region.

9. Pause the pointer over the page explorer button  and click Page1.

10. On the Source tab, expand Retailer site and drag Region to the left of Order method.

    Tip: Drop Region into the crosstab when a flashing vertical bar appears between the Product line column and the Order method column. Otherwise, Region may appear as a nested row instead of a column.

11. Click Region.

12. In the Properties pane, double-click the Sorting property.

13. From the Data Items pane, drag Region to the Sort List pane.

14. Click the sort order button  to sort quarters in ascending order and click OK.

15. Run the report.

---