Create 2 views.
View1 Consists the information of Question 1.
View2 Consists the information of Question 2.
Create a action when user click on View1 Data has to filter on View2.
Thanks for the response, however, there are 30+ questions for each survey program, we can only make the dynamic question view, since each program may have quite different questions.
The answer statistics are calculated based on question NO and answer options, will also different based on different survey program.
The Action method can only drill down(through) from one view to another sub-view, however, we have to list the sub-view under the master record dynamically.
It's one of very common BI requirements, to display the master record and the related drill down content & chart looply.