ACROSS usage code

Additional columns of data are created, grouped, and summarized according to the values in the column that is assigned the ACROSS usage code.

Reports:

A column can have a usage of ACROSS only if one or more columns has a usage of GROUP and one or more columns use aggregations. The summary line for each group value can contain several sets of results from the columns that use aggregations. There is one set for each group of values in the column that uses ACROSS. The heading for a column that uses ACROSS has three levels:

  1. The column heading as entered on the form
  2. The set of values within the column
  3. For each value in the set, the column headings for columns with aggregations

If more than one column has a usage of ACROSS, QMF accepts the first ACROSS and omits the remaining ACROSS columns from the report. If one column has a usage of ACROSS, no other column should have a blank usage. If you leave a column usage blank in an across report, QMF runs the report but omits all columns with blank usages.

The Across summary column (Area I) in FORM.OPTIONS shows an example across summary report with averages across columns.

Charts:

The information about reports also applies to charts. ACROSS on charts displays a category of data (such as JOB) broken down into subcategories (such as SALES and CLERK) within a larger category (such as DEPARTMENT). The data for these subcategories is displayed in a bar chart. Color display devices show the bars in different colors for different subcategories.