Hello. I have survey data in a fact table. 7 questions each with responses 1
- 5. Thanks to some posts here I figured out to have 7 answer dimensions (all
related back to a single table). I can show how many answered a specific
question 1, 2, 3, 4, 5. But I can't figure out how to show how many answered
a specific response for all questions on the survey as a whole

Given table survey_fact with fields Q1Answer, Q2Answer, etc... and dimension
table d_answer with 5 rows, how might I do this? TIA.

Ken