Last modified by - 7 days ago
1 min read

How do I create summary fields from the free USA Country demographic projections?

The new U.S. county level projection data contains numerous fields of population data by year, age, gender, and race. You can combine multiple fields (such as all the fields containing "2050" in their name) to create a total field (e.g., total 2050 population).

The following steps outline how to create a formula field that summarizes many fields:

  1. Add the county projections layer to a map and make it the working layer.
  2. Right-click on County Pop Proj in the Display Manager and choose New Dataview.
  3. Click Formula Button on the Standard toolbar.
  4. Click Statistics.
  5. Make sure that Sum is chosen in the Statistics drop-down list and click Choose Fields.
  6. On the left side, highlight the fields you want included in the sum and click Add>>. You can use the filter to naroow down the left side.  
  7. Click OK.
  8. Click OK.
  9. In the Formula Fields editable drop-down list, type a name for the summary field.
  10. Click OK. Maptitude adds a field to the dataview that contains the sum of all of the fields you chose.