Building stable report based on CROSSTAB query is not easy because of dynamic nature of fields.
You will likely have to build 2 CROSSTAB queries and then join them.
Review
http://allenbrowne.com/ser-67.html
Weekly grouping is even more complicated. Do you want a week to be 7 days Sun-Sat regardless of month or year? In other words, what do you want to do about weeks that cross months and years?
Also, tables and queries have 255 fields limit. A year has 365/366 days and 52 weeks - that's 417/418 fields.
What period do you want on report? 1 month? 1 year?