Filtering table fields to show unique values

The Unique Filter options allows you to filter data so only one occurrence of any repeating value is returned.

Steps:
  1. Start ArcMap.
  2. Load a map document that contains a graphic table element.
  3. Verify that you are in layout view if necessary.
  4. Right-click the graphic table element and click Properties.

    The Table Properties dialog box appears.

  5. If necessary, click the Data Source tab.

    The Data Source tab appears.

    Data Source tab
  6. Click the data source you want to use in the Data Source list on the Data Source tab.

    The chosen data source is highlighted, and the Filters button becomes available.

  7. Click Filters.

    The Data Filters dialog box appears.

    Data Filters dialog box
  8. Click Add Filter on the Data Filters dialog box and click Unique Filter.
    TipTip:

    You can also right-click in the Filter area and click Add Modify Filter > Unique Filter.

    The Unique Options dialog box appears.

  9. Click Add Table Fields.
    TipTip:

    You can also right-click and click Add Table Fields.

    The Table Fields Selector dialog box appears with a list of data source fields for selection.

    Table Fields Selector dialog box
  10. Click to choose the field you want to add.
    TipTip:

    You can choose more than one field by pressing CTRL and clicking additional fields.

  11. Click OK.

    The Unique options dialog box appears.

  12. Repeat steps 9–11 if necessary until all the fields you want are added.
  13. To further refine data source filtering, you can copy, delete, or sort rows or copy cells.
    1. To copy a cell, right-click a cell and click Copy Cell.
    2. To copy a row, right-click a row and click Copy Selected Row.
    3. To delete a row, right-click a row and click Delete.
    4. To sort a row, right-click a row and click Move Up or Move Down.
    Sort Option dialog box shortcut menu
  14. Click OK.

    The Data Filters dialog box appears with the filter table populated with the filtering options you have defined.

    Unique filter
  15. To further refine data source filtering, you can copy, delete, and sort rows; copy cells; or modify properties.
    1. To copy a cell, right-click an operator or filter type cell and click Copy Cell.
    2. To copy a row, right-click an operator or filter type row and click Copy Selected Row.
    3. To delete a row, right-click a row and click Delete.
    4. To sort a row, right-click a row and click Move Up or Move Down.
    5. To modify or redefine the filter configurations you defined previously, right-click a row and click Properties.
    Filter shortcut menu
  16. Click OK on the Data Filters dialog box.

    The Table Properties dialog box appears.

  17. Click OK.

6/14/2012