I have conducted a survey and stored the data using star schema.
My fact table looks like this..
I have 4 charts, each one for a question.
Requirement: When I select chart 1 for a response (lets say I selected Answer_ID=1), I want to show all the response_IDs in chart 2,3,4 that answered '1' in Q1.
Current situation: When I selected Answer_ID=1, it filters the whole data set with (Question_ID =Q1 & ANswer_ID=1) and blanks all other charts.
I want filtering within rows instead of columns. One of achieving this is to make all the questions a 'dimension' but I will lose my schema in that case.
Does anybody have a solution for this?