Display SurveySent, SurveyReceived and SurveyStat in the same crosstab

[bioCam]

Hi,

Surveys are sent to Regional Offices; it has 8 questions (each has 5 answer choices - Very Good, Good. .etc... Poor)  and 2  open texts.

The Stat Fact table contains the Survey's 8 questions/feedback choices + both open texts questions.

The Survey Dim table contains the Survey that's been sent to the Regional Offices and it has a flag to indicate if the survey has been responded and received by HQ.

Query 1 - contains the # Survey data (from Survey Dim)
Query 2 - contains Answer_Stat (from Stat Fact)

I need to join Query 1 and 2 so I can display the results in the same cross tab.  But I am not able to combine both Queries into a single Query (as they are different granularity - one at Survey, the other questions).

The crosstab report row displays the Regional Offices.

Column 1 = # Survey Sent (display count of Survey sent to the Regional Offices)
Coolumn 2 = # Survey Received (display count of Survey received by HQ from the Regional Offices)

Column 3 = Question 1, Column 4 = Question 2, ..Column 9 = Question

These columns ( 3 to 9) will display Answer_Stat (there is a formula to calculate the Answer selected / count Survey received)

Do you have any suggestions what I can do?  Thank you in advance.