Open topic with navigation

Create a Crosstab Query

Steps

1. Access the Design workspace.

2. In the page heading, select the drop-down list box, and then select Crosstab Query.

   The Conditions section is updated to include the following rows:

   • Field
   • Alias
   • Table
   • Total
   • Crosstab
   • Sort
   • Sort Index
   • Criteria
   • Or

3. For the fields that you want to use as column headings in the Results workspace, in the Crosstab cells, in the drop-down lists, select Column Heading.

   IMPORTANT: The Total cell that corresponds to at least one field that you want to use as a column heading must be set to Group By.

4. For the fields that you want to use as row headings in the Results workspace, in the Crosstab cells, in the drop-down lists, select Row Heading.

   IMPORTANT: The Total cell that corresponds to at least one field that you want to use as a row heading must be set to Group By.

5. For the field that you want to use as the aggregate (i.e., the intersection of the row and column), in the Crosstab cell, in the drop-down list, select Value.

   IMPORTANT: For the field that you selected as the aggregate, the Total cell cannot be set to Group By, Expression, or Where. Also, you cannot use as the aggregate a field on which a numeric expression is defined, or an error will appear when you run the query. Additionally, if you enter text in the Criteria cell for a field that is selected as the aggregate, an error will appear when you run the query.

6. After you have made your selections, in the page heading, select to run the query and confirm that it returns the appropriate results, and then save the query.

Copyright © 2018 General Electric Company. All rights reserved.