Hello,
I need to provide monthly count of opened and closed issues along with a count of issues dispatched to resolution queue.
I am able to add the date field and group by month in the column section fine.
The problem is that when I add more than one field in the row section, it does not display right.
So that the rows are labeled correctly, I have created formulas where:
Formula - Opened = Date Created
Formula - Closed = Date Closed
Formula Dispatched = dispatch table can have multiple dispatches, I am only interested the "dispatch for closure" and I think I can work on that formula with max date etc.
How do I display the following:
Jan 2012 Feb 2012 and so on
Opened 10 20
Dispatched 8 15
Closed 6 12
In the Summary section, I just want to pull the 3 fields and do a distinct count.
My crosstab can only accept either one of the fields in the rows.
What am I doing wrong.
IP Logged
