Need summary column in the attached 10g RDF file. [message #431786] |
Thu, 19 November 2009 08:17 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
|
Below is the query i have written for matrix with group
SELECT d.dname, e.job, d.loc,SUM (e.sal)
FROM emp e, dept d
WHERE e.deptno = d.deptno
AND e.job in ('CLERK','MANAGER')
GROUP BY d.dname,e.job,d.loc
Use scott schema since i was using that..
Am using d.loc as matrix group
e.job as matrix column
d.dname as matrix row
and sum(e.sal)as matrix cell field
in the total field am using sum(e.sal) again to find the total
-
Attachment: MODULE1.rdf
(Size: 52.00KB, Downloaded 1342 times)
|
|
|
|
|
|
|
|
|
Re: Need summary column in the attached 10g RDF file. [message #432101 is a reply to message #432099] |
Sat, 21 November 2009 03:33 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
|
Thanks ram.
I was using matrix with group while using with group i find difficulty to find the sum of columns ..I mean column summary per job,.
I have seen your rdf file in that u have used matrix only.Since am not using the same report which i have been attached here.its the sample one .
Thanks again for supporting ,
Syed
|
|
|