• On the Fields tab select zip code
     
    • Run the report



    To report on the cities of the zip code:
     
    1. Create a constituent query
     
    • On the Criteria tab, do not select any filters
     
    • On the Output tab, select:



      Addresses, Preferred Address/Specific Address Type/All Addresses/Address Processing (whichever is appropriate), City

      Addresses, Preferred Address/Specific Address Type/All Addresses/Address Processing (whichever is appropriate), ZIP


       
       
    • Select City and drag it from the PivotTable Field List to the Drop Row fields here field
     
    • Select ZIP and drag it from the PivotTable Field List to the Drop Row fields here field
     
    • Select Constituent Count and drag it from the PivotTable Field List to the Drop Totals here field