ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

ArcMap

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • Extensions

Filtering table fields to limit the maximum number of items returned

Available with Production Mapping license.

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

  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.

    Tip:

    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.

Related topics

  • What is a graphic table element?
  • A quick tour of the graphic table element

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS
  • ArcGIS Developer
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2021 Esri. | Privacy | Legal