Filtering data items for unique values

Data item table fields can be defined so only one occurrence of any repeating value is returned.

  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 Data Items on the Data Source dialog box.

    The Data Items dialog box appears.

    Data Items dialog box
  7. Click Operations.

    The Operations Order dialog box appears.

  8. From the Available Operations list, click UNIQUE.
  9. Click the Move button Move.

    The UNIQUE option is added in the Operations Order list.

  10. Click OK.

    The Data Items dialog box appears, and the Unique Options button is enabled.

    Data Items dialog box with Unique Options enabled
  11. Click Unique Options.

    The Unique options dialog box appears.

    Unique options dialog box
  12. See Filtering table fields to show unique values for complete information about using the Unique options dialog box.