| 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')
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
