Here's my challeng that I'm hoping you can help with. I have a report (see attached) showing the dates our students completed a class (in column A), and the region where they are from (in Column B)
Column A = Date
Column B = Region
I want a summary to show how many from each region took the class each month. Sort of like this:
North
Jan 3
Feb 5
Mar 4
Total 12
South
Jan 2
Feb 6
Mar 3
Total 11
OR it could be formatted as such:
Jan Feb Mar Total
North 3 5 4 12
South 2 6 3 11
I was able to create a pivot table to show how many students from the region took the class. But I am not able to then take the total for a region and separate it out by months.
Thanks in advance.
Column A = Date
Column B = Region
I want a summary to show how many from each region took the class each month. Sort of like this:
North
Jan 3
Feb 5
Mar 4
Total 12
South
Jan 2
Feb 6
Mar 3
Total 11
OR it could be formatted as such:
Jan Feb Mar Total
North 3 5 4 12
South 2 6 3 11
I was able to create a pivot table to show how many students from the region took the class. But I am not able to then take the total for a region and separate it out by months.
Thanks in advance.