Sub Summary Part Help

[Aaron23]

I'm trying to add a summary or sub-summary (not sure which is appropriate) to a report. I want the sub summary to show a count of different items selected in a drop down list box.

What I've tried to do is create a summary field of the drop down list which is a "count of" the field I want to summarize. Then place that summary field in the sub summary layout part. But when I view the report it's just giving me a count of all records in the found set instead of showing me the breakdown.

For example the field I want to summarize has 5 statuses "sold", "lost", "bidding" and so on ... On the report I want to see:

Sold: ## Records

Lost: ## Records

Bidding: ## Records and so on

But I'm just seeing ## Records.

Any help is very appreciated.