Counting # of Records

Good morning;

I am hoping someone can shed some light as to how to do the following.

I would like to get a count of each job level number by Org unit for each month (excel data is attached).

For example for the month on November i should get 13 Level 6, 4 level 7, 17 level 8 and 4 level 9

Thanks for the help

Workflow

Accepted answers

This task is very simple in Alteryx!

Use Summarize Tool and Group By Month and Count Level, and then Count by Count Level.

One single Summarize Tool will be able to perform this.

Cheers,

This task is very simple in Alteryx!

Use Summarize Tool and Group By Month and Count Level, and then Count by Count Level.

One single Summarize Tool will be able to perform this.

Cheers,

thank you, made it harder than it needed to be.