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.