|
|
|
|
|
|
| Re: subject total in matrix with group report [message #687450 is a reply to message #687449] |
Fri, 10 March 2023 10:36   |
 |
Barbara Boehmer
Messages: 9104
Registered: November 2002
Location: California, USA
|
Senior Member |
|
|
Please see the following sections of Oracle® Reports Building Reports 10g Release 2 (10.1.2).
This section gives a detailed example that you can follow one step at at time.
25 Building a Matrix Report
https://docs.oracle.com/cd/B14099_19/bi.1012/b13895/orbr_matrix.htm
This section should be particularly helpful
25.4 Add summaries to the single-query matrix
https://docs.oracle.com/cd/B14099_19/bi.1012/b13895/orbr_matrix.htm#i1012661
If you follow the full example and compare to what you have, then all you need to do is substitute your column names for the ones in their example. Here is an excerpt
"25.4 Add summaries to the single-query matrix
To make your matrix report more useful, you should add summaries of each row and column in the matrix, and the whole report. In the single-query case, you can add these summaries very easily with the Report Wizard. In the multiquery case, you would need to add the summaries manually and then use the Report Wizard to create fields for them.
The steps below describe the procedure for adding summaries to the single-query matrix.
To add summaries to a single-query matrix:
Return to the Report Wizard by choosing Tools > Report Wizard.
Note:
Although you can use the Report Wizard to add summaries to a single-query matrix, you cannot use this method for a multiquery matrix.
On the Report Type page, select Create Paper Layout only.
On the Totals page, click SUM_SAL in the Available Fields list, then click Sum.
Tip:
You may have to use the arrows to make the Totals tab visible.
Click Finish to preview your report output in the Paper Design view.
Note:
When your new layout is created, you should notice a couple of things. First, at the bottom of each column of the matrix, you should now see a summary of that column's values. The report is also probably more than one page long now. Because of the width of the layout, the summaries for the departments cannot fit on the page with the rest of the matrix. Hence, the department summaries and the report summary overflow to the next page. Go to the second page of the report and you will see the department summaries and the report summary."
If this is not sufficient, then please post the query that you used to create what you have posted.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
