Defining the structure of the Cross-Tab

Add fields to the Rows, Columns, and Summarized Field areas.

1. From the Customer table, click Region, then click Add Row.

   The Region field is added to the Rows area.

2. From the Product table, click Product Class, then click Add Column.

   The Product Class field is added to the Columns area.

3. From the Orders table, click Order Amount, then click Add Summarized Field.

   The Orders Amount is added to the Summarized Field area.

   

4. Apply additional structure by:
   • Adding formulas to any of the fields - select the field then, click New Formula.

     For more information see Working with the Formula Editor.

   • Defining the sort method - select the field then, click Group Options (ascending, descending or specified order).
   • Changing the summary operation - select the field then, click Change Summary.
5. Click Next.

   The Style tab appears.