How to achieve single table with separate column for each field entry?

[tlmayes]

I am working producing a table that calculates the number of incidents resolved by each analyst. 

What my query does is produces a table with three columns with a count of 'Class Names':
Analyst / Class Name / count

What I am trying to do is produce an output with (4) columns with a count under the descrete columns and a total of the row to the right:
Analyst / Class Name 1 / Class Name 2 / Total Count (of all class names)

<query>
| table "Analyst" "Class Name"
| stats count by Analyst "Class Name"

[ITWhisperer · Accepted solution]

<query>
| table "Analyst" "Class Name"
| chart count by Analyst "Class Name"
| addtotals

[tlmayes]

This, this resolution works