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 :-)