Filtering and Ranking a Geographical Map

Create a Filter for a Geographical Map

To create a filter for the geographic hierarchy in a geographical map, complete these steps:
  1. Right-click on the geographical map, and then select Filter and Rank to open the Filter and Rank dialog box.
  2. Select the Category Filters tab.
  3. In the Categories list, select the geographic hierarchy. This field displays the geographic hierarchy along with any currently active filters.
  4. In the Filter type drop-down list, select Filter.
  5. Select items in the Available values list. You can select and deselect items individually, or you can use the Select All or Deselect All buttons.
  6. Click OK.

Create a Measure Filter for a Geographical Map

Note: The Measure Filter or Rank tab is not available if the geographical map is part of a synchronized group. For more information, see Using Synchronized or Independent Objects.
To create a measure filter, complete these steps:
  1. Right-click on the geographical map, and then select Filter and Rank to open the Filter and Rank dialog box.
  2. Select the Measure Filter or Rank tab.
  3. Select the Filter option.
  4. In the Show values of drop-down list, select the geographic hierarchy.
  5. Select the Measure that is being used in the geographical map.
  6. Select an Operator.
  7. Enter a Value. (Do not include the currency symbol.)
  8. Click OK.

Create a Ranking for a Geographical Map

Note: The Measure Filter or Rank tab is not available if the geographical map is part of a synchronized group. For more information, see Using Synchronized or Independent Objects.
To create a ranking for the measure used in a geographical map, complete these steps:
  1. Right-click on the geographical map, and then select Filter and Rank to open the Filter and Rank dialog box.
  2. Select the Measure Filter or Rank tab.
  3. Select the Rank option.
  4. In the Show field, select Top or Bottom, and then type a value next to the option that you chose.
  5. (Optional) Choose one of these options:
    • To evaluate the data as a percentage, select the percent(%) option, and then enter a value. The value cannot exceed 100.
    • To exclude tied rankings, select the Exclude ties option. For example, by default, if you request the top five geographic areas for total revenue and there are three areas tied for fifth place, then seven geographic areas are shown on the geographical map. If you select the Exclude ties option, then only five geographic areas are shown on the geographical map.
  6. In the Show values of drop-down list, select the geographic hierarchy.
  7. Select the Measure that is being used in the geographical map.
  8. Click OK.

Remove a Filter or Ranking from a Geographical Map

To remove a filter or ranking from a geographical map, complete these steps:
  1. Right-click on the geographical map, and then select Filter and Rank to open the Filter and Rank dialog box.
  2. Remove the geographic hierarchy filter, the measure filter, or the ranking as described next:
    • On the Category Filters tab, select the geographic hierarchy, and then select No filter.
    • On the Measure Filter or Rank tab, select No filter (show all values).
  3. Click OK.
Copyright © 2009 by SAS Institute Inc., Cary, NC, USA. All rights reserved.