Hi

I've created a dashboard that I would like to be dynamic. The file has three tabs:

1. Simulator: with the dashboard
2. Data: with the data I'm willing to use
3. Table: with tables showing the results/proportion. (This is only for me to check that the formula is working properly and I'm showing the right results)

I would like to build something that allows me to select a message (or a combination of different messages) and automatically pull the data from the data Tab and show the proportion split by country (F4:F8) and counts (E4:E8). Also, I would like to show the messages selected (S4).

Since this this is a multiple select question if a respondent select more that one the counts could be higher than the base. However, the proportion is based on the number of respondents in each country. I hope this is clear.

For example, in the US there are 124 respondents and only 37 selected A1 or/and A2, so: 37/124=29.8%

If nothing is selected I would like to see blank at E4:E8;F4:F8 and S4.

Please, let me know if you need more information.

Thanks for your help.

simulator.xlsx