Home » Developer & Programmer » Reports & Discoverer » Re: compute sum of a columns row wise and column wise
Re: compute sum of a columns row wise and column wise [message #88846] Mon, 05 May 2003 01:35
Shariff Issa
Messages: 1
Registered: May 2003
Junior Member
I am designing a report that shows a cumulative result of detailed income statement to be used by management.

A part of a report should have this format:

month/total JAN FEB MAR Total1
Salaries - 1 3 4 8
Salaries OT 2 3 4 9
Total2 3 6 8 17

My problem is how do I get the sum on the columns, Total2.
I am fine with the sum of the rows i.e. Total1
This is not a Matrix report.

Input parameters is month and year.For example part of the query may look like:

select to_char(ref_date,'MM'),
to_char(ref_date,'Mon'),
sum(debit)-sum(credit)
from post_det
where to_char(ref_date,'YYYY')='2003' and
to_char(ref_date,'MM') between '01' and '03'
and substr(chart_code,12,2)='43'
and substr(chart_code,12,4)!='4390'
group by
to_char(ref_date,'MM'),
to_char(ref_date,'Mon')
Previous Topic: Oracle Discoverer
Next Topic: problem with opening comma seperated report file in internet explorer
Goto Forum:
  


Current Time: Thu Jul 09 12:49:56 CDT 2020