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.
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:
- The column heading as entered on the form
- The set of values within the column
- 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.