Crosstab query using the DB2 stored procedure
Posted on 2006-05-09
I have a table called Problems with the following columns & data.
Table Name: Problems
Tkt# Problem_Code Resolver_Group Reporter_Group
22 Closed ABC Mechanical
33 Closed FC ABC IT
11 Resolved XYB Mechanical
04 Open IT
99 Closed FC XYB HR
14 Resolved PYT FI
09 Closed XYB HR
I want to produce the Cross tab report with the following format :
Resolver_Group Closed ClosedFc Total
ABC 1 1 2
XYB 2 1 3
PYT 1 0 1
Criteria for producing the above ourptut:
Exlude Open Ticktes
CLOSED = Closed & Resolved Tickets
CLOSEDFC - Closed-FC ticketes
Total = Total number os Closed & Closed Fc tickets.
Please let me know the solution as soon as possible.