Set Analysis w/Variables - show one value in a list

[ccifaldi]

Hello! I am using set analysis with variables to create dynamic bar charts. Users should be able to select a question from a filter list and then see a bar chart that contains percentages per each response option. In my example there are 4 options to choose from: North America, EMEA, Asia-Pacific and Latin & South America. I have successfully used variables on the question and list of all responses part. I am stuck on how to limit each bar to one response. Attached are images. 

Desired End Result:

Set analysis:

Dim/Mea:

[Digvijay_Singh]

Not able to understand completely, please share your current chart to understand more about the problem.

[ccifaldi]

Hello! How should I post that for you? .qvd?

[SunilChauhan]

Better share some sample Data , as requiredment not clear . Need more info to work

[ccifaldi]

Thank you! Here is a sample of the raw data. There are two columns "Question" and "Response". What I would like to do is have variables working to create the charts because we have thousands of questions and their related responses in our actual dataset. The idea is to allow users to log on to one sheet in an app and select one question at a time and have the graph dynamically work. I can do this in a rudimentary way, but, we need to apply custom filters and eventually create year over year and stacked bar charts with our data that are dynamic.