Hi experts,
Iu2019m trying to create a WAD u2018dashboardu2019 "Spend by Supplier" within a map based on 0COUNTRY and 0REGION,
I would like to display it in a single map by country, and then drill down to region, but how do I make this work?
Iu2019ve 2 data providers, one based on the original query (Spend by Supplier , 0COUNTRY in rows) and on a view based on this query (with 0REGION in the rows).
Ideally I like to display everything in 1 single map, where first the countries are highlighted with the colour shading based on certain criteria, and once I make a selection in the table for any country, the regions should be highlighted with the same colour shading.
I did create 2 map layers but the result is not correct yet. Does anybody have any idea? I did look up most posts here on the forum, and on the internet, but I can't find a proper explanation on how to drill down in the map from country to region.
If possible please describe a step by step guide.. much appreciated!
Thanks
Markus