So I created a subquery, then I created another query to query my subquery and this is what I have. I think it works, I only have data for 1 month right now, so I cant check it to see if it works for other months. Then I linked it to excel as a pivot table and filter by month.
SELECT *
FROM...