Selecting a CrossTab Report Style

If your final dive window is a CrossTab with two dimensions and a summary, you have one option for converting the dive into a CrossTab style report: Basic CrossTab. The shows dimension values in the leftmost column (Suppliers) and horizontally (Ship Month) across the top of the report. Totals for all row values display in the final column on the right. A total line displays at the bottom of the report, summing the revenue totals (if selected as the summary) for the horizontal dimension (for example, the total monthly revenue) for all suppliers. Individual report cells display summary values (Revenue) for the intersection of dimension values (for example, the total revenue for a given supplier and ship month).

The following steps show how to create a CrossTab dive window with two dimensions (Supplier and Ship Month) that gets converted into a standard report by selecting the Basic CrossTab report style. This procedure enables you to visualize the formatting impact of choosing the basic report style for a CrossTab.

  1. Select a server with a project that contains a sales model with dimensions and summaries, such as:
  2. Supplier, Brand, and Ship Month
  3. Cases, Revenue, and Cost
  4. For illustration purposes, this procedure refers to a sales model called sales_90day.
  5. In ProDiver, locate and open sales_90day.mdl.
  6. On the Console, double-click Supplier to open a basic tabular dive window.
  7. Click the Cross Tabular icon to open Closedthe CrossTab dialog box.
  9. Select Ship Month as the Horizontal Dimension and Revenue as the summary Column.
  10. Click OK to create Closeda CrossTab dive window.
  12. To convert the dive window into a CrossTab report, click the Report icon and accept Basic CrossTab as the report style.
  13. Click OK to Closedgenerate the report.

NOTE: A copy of the sales_90day.mdl file is located in a zip file in Data Source for Advanced Report Writing. You can open it in ProDiver if you want to duplicate this exercise.