Create a chart showing frequency

[prose3]

Hi all,

I'm trying to throw together a "heatmap," but the heatmap tool is not doing what I need.

I have a set of data that has a list of reviews, when they were performed, and by whom:

Review ID	Month	Director
1	Jan	John
2	Feb	Mary
3	Jan	John
4	March	John
5	Feb	Mary

I'm looking for an output of a chart that shows the frequency of reviews by Director by month:

Director	Jan	Feb	March
John	2	0	1
Mary	0	2	0

Apologies if this question is posted somewhere else, I can't find the name of the chart I want and don't see anything related. Thanks!

[alexnajm · Accepted solution]

Looks like a Crosstab tool to me to get this data in the correct way! Group on Director, change column headers to Month, and values to Review ID (aggregating by count)

[prose3]

Thanks, that was it! My review IDs weren't numbers so once I converted I was able to get the aggregate by count option.