Hello,

I would like to display the data below in a report. I want to use the column CH and add columns (closed and open) instead of using count and Status in the report. So it would be CH, Closed, and Open. The closed and open would contain the count totals. How would i do this? Do I need to change my query (the source of the data)?

CH

CountStatusMARK3ClosedMARK1OpenJOHN8ClosedJOHN3OpenTOM1ClosedSTEVE7ClosedLUCY1ClosedMADISON1ClosedJENNY1ClosedJOEY1ClosedBECKY1ClosedTURNER1OpenCHEEK4ClosedSTEFF1ClosedWES1ClosedRAY1OpenBOB3ClosedABE2OpenGEORGE2Closed

It would look like this....

CH Open Closed
MARK 1 3
JOHN 3 8

ETC....