Filtering table fields for sorting

Additional filtering options allow you to add table fields to a sort list and filter the data by the sorted list.

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

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

    The Sort 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 Sort 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. To sort a table field in ascending or descending order, click the cell next to each field and choose an option from the drop-down menu that appears in the Sort Order column.
  15. Repeat step 14 to sort each table field if necessary.
  16. Click OK.

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

    Sorting filter
  17. 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
  18. Click OK on the Data Filters dialog box.

    The Table Properties dialog box appears.

  19. Click OK.

7/31/2012