SURVEY QUESTIONS how to drill down

[KarlaR]

Hello!

Im trying to do a dashboard where i can present the results from a survey. This survey is divided in principal questions and detail questions. Each principal question, has 4 detail questions. I wanted to use hierarchies in orden to present first, the results from the principal questions and when clicking on each question be able to the results from detail question. However, as every question (principal and detail) was answerd by 350 people, when doing the hierarchy, for principal questions it doesnt count 350 answers, it counts 350x4= 1400 answers because it contains the answers from the 4 detail questions. Does someone know another way to present this results? or how can i make hierarchy work in this situation?

Example in pictures. In the 1st one you can see on the Axis the principal questions, the different colors represent how the answers are being distributed. When i click on "Bonificaciones" i can see the detail answers on the axis (2nd picture) and also its answers distribution.

[Vvelarde]

@KarlaR

Please post sample data to agilize the answers.

Thanks