Building the Report

Let’s build the report that will show those cities of the United Kingdom, where the value of the Reseller Sales Amount measure for all products in 2018 is more than 100 thousand. To do that, drop the “Geography / Country” to the context designer and select “United Kingdom”, then drag in the context designer “Date / Date.Calendar Year” and select 2018. In the item designer, drop the “City”. To the “Latitude/Llongitude” drag “Latitude” and “Longitude ” measures, “Reseller Sales Amount” measure drop in the color designer:

Now let’s create a filter that displays only cities on the map, for which the value of the “Reseller Sales Amount” is more than 100 thousand. To do this, add the following filter in the “City” hierarchy:

After that you will see the following: