Hello,
I want to create a simple pie chart, the query is quite simple:
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.Code:SELECT Complaints.[Category], Count(Complaints.[Category]) AS CountOfCategory FROM Complaints GROUP BY Complaints.[Category];
What am I doing wrong?