I have a list of company and their relative headquarters location in the following form: region/subregion/country -Our file contain 'ContryTable' tab
With 'region' I mean for instance Asia, Europe, Africa; while for subregion I mean for instance 'Eastern Asia'.
From that list I have created a pivot table which gives me how many companies there are for each subregion.
Finally, I have created a map chart from that pivot table and a filter to show region by region.
When I click on 'South America' or 'North America' or "Africa' in the filter, the map shows me properly those regions by zooming in. If I click on 'Europe', 'Middle East' or 'Oceania' the map does not zoom in, this is because the mapping between the regions and the country is wrong according to Bing.
I am looking for someone able to fix this problem, in particular:
1. The map should zoom in properly everywhere on each region
2. Currently the map work with the subregions, I want to make it work with the region.
About the recuiterMember since Nov 11, 2022 Jignesh Patel
from Primorsko-Goranska Zupanija, Croatia