Hello,



I want to create a simple pie chart, the query is quite simple:

Code:
SELECT Complaints.[Category], Count(Complaints.[Category]) AS CountOfCategory
FROM Complaints
GROUP BY Complaints.[Category];
When I run the query I get number of complaints per category. However in the report several charts are displayed instead of one. Actually, the number of charts is the same as number of the records in Complaints table.

What am I doing wrong?