A script-enabled browser is required for this page to function properly.

Creating a matrix (cross-product) group

You can define matrix groups in the Data Wizard or create them manually.

To create a matrix (cross-product) group using the Data Wizard:

  1. In the Data Model view, right-click and choose Data Wizard.

  2. On the Query page, select the Matrix query check box.

  3. Follow the wizard to select the columns for the matrix group(s), rows, columns, and cells.

To create a matrix (cross-product) group manually:

  1. In the Data Model view, drag the title bar of the group object down.

  2. Drag the "row" column and "column" column out of the group object into the space to create two new groups.

  3. Single-click the Cross Product tool in the tool palette.

  4. Drag a box around the groups you want to include in the matrix (cross-product) group.

  5. If the cell group is a separate query from the matrix (cross-product) groups, create the appropriate links between the columns in the matrix groups and the cell group.

Next step

Creating a default layout for a report

See also

About matrix objects

About matrix reports

About matrix with group reports

About nested matrix reports

Creating a matrix object

Creating a nested matrix report