1. Go to Control > Query 
  2. Click New 
  3. Select All Contacts Query
  4. Select Last Transaction Amount
  5. Click Add 
  6. Select and type > 0
  7. Select Last Transaction Type > Click Add > Select Is One Of Gift, Order, Payment
  8. Click Next > Select the field(s) you want to display or export
    • Notes: Recommended fields in addition to Profile Fields: ​Last Transaction Amount, Last Transaction Type, Last Transaction Date
  9. Click Next > Sort the report by a specific field if needed
  10. Click Finish