ACROSS Usage Code

Reports: A column can have a usage of ACROSS only if one or more columns have a usage of GROUP. In that case, 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.

For an example of an across summary report with a usage of AVG, see  I Across summary column? on page***.

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 terminals display the bars in different colors for different subcategory bars.