Can't seem to find the answer myself, so I'll ask the pro's once again.
I have a table where instances of defects on manufactured parts are logged. I would like to create a query, and subsequently a Pivot Chart, that shows the number of instances for a particular type of defect.
(Example) Query would return:
Burrs : 2 (instances)
Damage : 2 (instances)
Dimensional : 4 (instances)
Surface Finish : 1 (instance)
I've attached a screenshot of the dataview of my query. Is this enough to go on or do you need more info? I tried messing with Total / Count but don't quite get it yet. Right now, all I'm able to do is count the total number of rows but cannot separate the totals by category?
Can you point me in the right direction?
Thanks.
Attachment 6238