U.S. Census Bureau
Tutorials

Learn more about the features and functions of American FactFinder

Skip left-hand navigation

Tutorial 6: Modify a Table

You must have the Adobe Flash Player plug-in offsite link icon installed to play this video.

Video transcript »

Skip video and media player

The Camtasia Studio video content presented here requires JavaScript to be enabled and the latest version of the Adobe Flash Player. If you are using a browser with JavaScript disabled please enable it now. Otherwise, please update your version of the free Adobe Flash Player by downloading here.

Video Transcript:

  • Welcome to the American FactFinder Modify a Table Tutorial.
  • In this Tutorial, we will demonstrate how to:
    • Show and hide rows of a table;
    • Collapse and expand data categories;
    • Rearrange columns and rows; and
    • Sort rows in ascending and descending order.
  • After viewing this tutorial, you will be able to perform basic modifications to change the display of a table in American FactFinder.
  • To begin, navigate to the American FactFinder main page at factfinder2.census.gov.
  • Click the Search button to display the search results page.
  • Select the table – "ACS Demographic and Housing Estimates 2008" from the Search Results.
  • The selected table displays.
  • Click Modify Table.
  • Notice the following:
    • A set of Table Tools displays that allow you to:
      • Reset the table;
      • Show hidden rows of the table; or
      • Transpose the rows and columns of the table.
  • It is important to understand that the tools displayed in the table are dependent upon the way the information is organized in the table you are viewing.
  • Below the table tools, a legend displays with a description of the modifications that can be applied to a table and
  • The table is updated with only those tools that are applicable to this table.
  • Let's hide some columns in the table.
  • Click the check boxes at the top of the 'Margin of Error' columns.
  • Notice the following:
    • The table view is updated with the 'Margin of Error' columns hidden.
    • A note has been added to the top of the table indicating that the table has been modified from its original display.
  • To restore the 'Margin of Error' columns, click on the 'Show Hidden Rows/Columns' button.
  • Now, let's collapse a data category in the table.
  • Click the Collapse button next to 'Total Population'.
  • The display of the 'Total Population' category is collapsed in the table.
  • You can easily expand the 'Total Population' category by clicking on the 'Expand' button.
  • Next, let's rearrange the rows in the table.
  • This feature enables you to:
    • Move rows up and down in the table and
    • Move columns to the right and left.
  • Click on the 'Move up' button next to the 'Black or African American' row in the table.
  • The row 'Black or African American' is moved above the row 'White' in the table.
  • Once you have finished modifying the view of the table, you can select the 'Hide Table Tools' button to print, bookmark or download the modified view of the table.
  • At any point during your table modifications, you can reset the table to the original view.
  • To reset the table, click on "Reset Table".
  • The original table view is restored.
  • To demonstrate sorting functionality, let's look at a different table.
  • Click "Back to Search" to select other tables or geographies.
  • Type "Economy Wide" in the 'Search within Results' box.
  • The search results are updated.
  • Select the table "Geographic Area Series: Economy-Wide Key Statistics: 2002."
  • Click "Modify Table" to display the table tools.
  • Let's select a column to sort.
  • Click on the 'Sort Ascending' button in the "Number of Establishments" column.
  • The table view is sorted in ascending order by number of establishments.
  • The 'Sort Ascending' button is highlighted to show that you are currently sorting the table by the number of establishments.
  • To remove the sort, click again on the 'Sort Ascending' button.
  • This concludes the Modify a Table Tutorial.
  • In this tutorial, you learned how to:
    • Hide columns in a table;
    • Collapse data categories;
    • Rearrange columns; and
    • Sort in ascending and descending order.
  • For more information visit American FactFinder at factfinder2.census.gov.