In your crosstab, your % of total table calc is set to use table across. This works with your first map since you're selecting a country and seeing all the response values. In your second version, you want to select a response and see all of the country values. To do that, you first need to set the table calculation to calculate using table down. Here's what the updated crosstab looks like (it's called cross table down in the attached workbook).
Now you can create a map off of the Country lat and long coordinates instead of the Response coordinates and switch the Country field with Response in the filter shelf. So when you select a Response country you'll see the percentages for all of the countries. This is on map (2) in the attached workbook.
surveytest_updated.twbx 408.5 KB
thanks for sharing your advice!
To stick with Austria as an example, following the ‘table down’ approach will yield the share of votes to Austria (of all votes that Austria received, ie ‘table down’, as in your table image).
However, what I would like to show in the view is the share of votes each country gave to Austria (of all votes each country gave). Sorry that this was not clear from my initial post!
The result from the table with ‘table across’ has all the correct numbers, I only need a way to display them by column (as in the highlight). Perhaps this calls for a new calculated field?
Any ideas are welcome! Many thanks again, Chris
If I understand your question right, you can use below approach
Create a parameter to toggle between response to and response from.
create calculate field Counrty_Calc which would be something like this
if Parameter = ‘Response To’ then [Response to Country ]
else [Response from Country]
Place the Country_Calc over your Country pill.
I managed to do what I wanted with the below LOD:
The result is a 'table across by column' (if that makes sense) for the country selected in the filter. A parameter can now be set to change between votes "by" a country vs. votes "to" a country.
Workbook attached. Thanks again for your help!
surveytest_solved.twbx 286.5 KB