![\"\"](\"http:\/\/bitimpulse.com\/wp-content\/uploads\/2024\/02\/6_233.png\")
<\/a><\/p>\nNow let’s create a filter that displays only cities on the map, for which the value of the \u201cReseller Sales Amount\u201d is more than 100 thousand. To do this, add the following filter in the \u201cCity\u201d hierarchy:<\/p>\n
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 \u201cGeography \/ Country\u201d to the context designer and select \u201cUnited Kingdom\u201d, then drag in the context designer \u201cDate \/ Date.Calendar Year\u201d and select 2018. In the item designer, drop the \u201cCity\u201d. To the \u201cLatitude\/Llongitude\u201d drag \u201cLatitude\u201d and \u201cLongitude \u201d measures, \u201cReseller Sales Amount\u201d measure drop in the color designer:<\/p>\n
Now let’s create a filter that displays only cities on the map, for which the value of the \u201cReseller Sales Amount\u201d is more than 100 thousand. To do this, add the following filter in the \u201cCity\u201d hierarchy:<\/p>\n<\/a><\/p>\n