data for a pie chart

[Una_R]

Hi folks

This should be simple but I have been struggling with the aggregation:

I want to present a simple summary (and eventually a pie chart) of the query data based on the test case status

test case   test case status
=====  ==========
test A    single result
test B    no result
test C    no result
test D    single result
test E    more than one result
test F    no result

summary should be

test case status  count
==========  ====
no result  3
single result 2
more than one result 1

This is driving me crazy as I thought I could just use the count distinct on the test case name (as I have in other reports to produce pie charts), but this always returns just one test case status ("more than one result")

Is there a standard way to do this? I am fairly new to Cognos reports!

Cheers