Need to print a crosstab report without complete data

[Lkwdmntr]

I made a spreadsheet with all the data, but I am not great at pivot tables. I tried to attach the Excel document, but it is not allowed (I need permission to download it). The report consists of 12 sub-forms to make it look like one form. A copy of the report showing the columns and rows is already in the system and attached. You can see on page 5 when we started to add more actions in week 4, where the problem arises. Since the prior weeks didn't have the information, they are not showing. Only a real crosstab will fix this. I did pull all the data into a spreadsheet, but I am not good at pivot tables. Let me know what else might help here.

 

[DHookom]

One of your issues is the lack of normalization. You have activities and engagements in fields across rather than creating new related records. I am attempting to normalize tblChallenges with a union query. It will take a little work.

How do you calculate Planned, Engagement, and Achievement values?