How can you determine a count of donors by fund?
  • 31 Jan 2023
  • Contributors
  • Dark
    Light
  • PDF

How can you determine a count of donors by fund?

  • Dark
    Light
  • PDF

Article summary

It's easy to get a count of GIFTS by fund, but much harder in FIMS to get a count of DONORS by fund.

Answer:
  1. Set up a data grid or use the User Defined Gift History Export choosing fund fields, etc. 
  2. Take into excel and do a pivot on fund on left as row and column as donors have gift as a count. 
  3. Do a count function on the right to count all the non 0 columns and that will give you the number of donors.
  4. Depending on foundation size, excel might have a problem with column count.

Was this article helpful?