Hi
I have records like below
__0MATERIAL STATUS_ DATE_
M1 OPEN 01/11/2007
M1 INPROCES 15/11/2007
M1 CLOSE 30/11/2007
I want the COUNT(number of open , number of inprocee, number of close) liie below
__0MATERIAL STATUS_ DATE_ No. Of. Open No.Of.InProcess No.Of Completed
M1 OPEN 01/11/2007 1 0 0
M1 INPROCESS 15/11/2007 0 1 0
M1 CLOSE 30/11/2007 0 0 1
Pls let me know how can i get the COUNT of 'No. OF Open' , 'No. Of. InProcess' , 'No.Of Completed' .
regards
kumar