Data Wizard: Matrix Totals page
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
.
Usage notes
- 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.