The Order By pane shows the columns used to sort the information in the report. The columns shown in this pane are the ones with check marks in the Order By column in the List of Columns pane. The order in which the rows are listed in this pane is the order by which the data is sorted. That is, the first (top-most) row is the primary order; the next row down is the secondary sort order; and so on for all rows. Use the large arrows to the right of the table to change the order of the rows. The Sort Order column indicates whether the sorting is in ascending or descending order. When the check box in the Make Group column is selected, instances of the same type are grouped together. This allows you to summarize the data in the report for each unique instance as well as all instances. For example, if you select the check box for Administrative Unit, each administrative unit is grouped together. Then, using the column that is added to the List of Columns pane, you would select which numeric columns will be summarized and how that data would be summarized. The report would then show the summary data values for the specified columns after each administrative unit. (If you also selected an aggregation type in the Total Aggr. Func. column, a summary value for all administrative units would be shown at the end of the report.)
Note: The Make Group check boxes must be selected in order from top to bottom. In other words, you cannot select the check box for the second row of the table if the first row is not also selected. For example, if you sorted a report by administrative unit (primary) and section class code (secondary), you cannot summarize data just by section class code. You would also need to summarize by administrative unit (or make the section class code the primary sort).
Overview
Content Tools
Apps
