A Statistical Report is set up to run on Gift Fund and the Total Donors column is added.
- Donor A gives to Fund 1, Fund 2
- Donor B gives to Fund 1, Fund 3
- Donor C gives to Fund 2
|Fund 1||2 (donors A and B)|
|Fund 2||2 (donors A and C)|
|Fund 3||1 (donor B)|
- If you add up the totals of Fund 1, Fund 2, Fund 3 -- that equals 5 because Donor A and Donor B gave to two funds each.
- However, the grand total is the total of unique or distinct donors -- that equals 3 to represent Donor A, Donor B, and Donor C.