Dynamic matrix based on two months

hi there my data is as follows

my report will have two filters.

Start date (lets say 01/01/2018) and end date (01/03/2018)

for these two days i would like a matrix like this

this matrix counts the cid that have each score for the selected months

example cid 1245 has score 1 in 01/01/2018 and score 3 in 01/03/2018 so the number 1 goes in the first row third column

i was thinking of creating a  dynamic group by with two columns that will have the score (each column for each month selected)

then put them in matrix