Filtering table fields to limit the maximum number of items returned

The Limit Filter option allows you to set the maximum number of filtered items to return.

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 Limit Filter.
    TipTip:

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

    The Limit filter properties dialog box appears.

    Limit filter properties dialog box
  9. Type the maximum number of filtered items you want returned in the Maximum number of filtered items text box.
  10. Click OK.

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

    Limit filter
  11. 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
  12. Click OK on the Data Filters dialog box.

    The Table Properties dialog box appears.

  13. Click OK.

6/14/2012