using pl/sql to format results! help!

[imose]

s1 s2 s3 s4
Total Open 999 999 999 999
Total Closed 999 999 999 999
Grand Total 999 999 999 999

above is the out put expected from a query. s1-s4 is from a single column with four severity levels in that column it has been taken apart to retrive the information

now how would you write this in pl/sql so that you can get the total in the s1 field in the s1 column where requests are open and the total in the s1 field where requests are closed?

thanks your help is appreciated :-)

[pando]

use dbms_output to display results and SQL functions to format them

[chrisrlong]

Can you be a little more specific?

What, exactly, does the data look like now?

- Chris

[imose]

issue
-------------------------
2 - Serious
3 - Moderate
3 - Moderate
2 - Serious
3 - Moderate
4 - Tolerable
3 - Moderate
2 - Serious
3 - Moderate
4 - Tolerable
4 - Tolerable

[chrisrlong]

Uh, okay, but what did you mean by 'results are open or results are closed'? There is no such information here.

- Chris

[imose]

issue defects
-------------------------
2 - Serious open
3 - Moderate closed
3 - Moderate open
2 - Serious closed
3 - Moderate closed
4 - Tolerable open
3 - Moderate open
2 - Serious closed
3 - Moderate closed
4 - Tolerable open
4 - Tolerable open
there is another column called defects that maps accross as stated thanks chris!