First, we will create a query to find all donors:
  1. Click Queries > Manage Queries
  2. Select a category that you want to store this query in
  3. Click New Query under the tasks menu
  4. Name the query All Donors
  5. Set the Starting Query to Base/All Constituents
  6. Under Results, set the Data Return Type to Accounts
  7. Under Criteria Options mark Match each criteria
  8. Under Browse Fields select Commonly Used Fields from the drop down menu and click on Individual Transaction Received 
  9. Fill in Greater Than or Equal To .01
  10. Click Save and View Queries
Then, we will create a report to group them by State/Province and show a total number of accounts:
  1. Click Reports > Manage Reports
  2. Select a category that you want to store this report in 
  3. Click New Report under the Task Menu
  4. Name the report
  5. Under Browse Fields, select Commonly Used Fields Fields in the drop down menu and click Account Name and State/Province
  6. Click on the three dots to the left of the Account Name column, and select Count as your Aggregate
  7. Highlight the name of the field and rename it "Number of Accounts"
  8. Scroll back up to Group Results, select to Group Report By State/Province and Collapse Groups
  9. Click Save and Run under the Task Menu
  10. Under Query select your category in the top box and your All Donors query in the bottom box
  11. At the bottom of the page select a Delivery Option and then click Submit