To specify totals functions for matrix fields:
Click a field in the Available Fields list.
Click the appropriate button for the function you want to apply to the field. An entry with the field and function name appears in the Matrix Totals list.
Repeat Step 2 for any other desired functions you want to apply to the field.
Repeat Steps 1 through 3 until you have created all of the desired totals.
(Optional) To remove a field from the Matrix Totals list, click it then click the left arrow (<).
Not all Oracle database datatypes are supported at this time.
will identify the datatype as unknown in the wizard if your query selects
an unsupported Oracle database datatype.
The functions you can perform on column objects and Ref columns are limited. Therefore, some functions are disabled when you select them in the Available Fields list.
For group reports, the Report Wizard creates n summary fields in the data model for each summary column you define: one at each group level above the column being summarized, and one at the report level. For example, if a report is grouped by division, and further grouped by department, then a summary column defined for a salary total would create fields for the sum of salaries for each division and each department group (group-level summaries), and the sum of all salaries (report-level summary).
Copyright © 1984, 2005, Oracle. All rights reserved.