HI,
I am trying to pull a list of donors who have donated for the past consecutive 5 years. I am having trouble figuring out the best way to pull this list. Any ideas?
Thanks!
One way could be using a combination of lists. You would create 5 individual lists of total donors in each year. Then in a sixth list you would ask for people that have all 5 of those lists. So your criteria would look like:List IN (list 1)List HAS (list 2)List HAS (list 3)List HAS (list 4)List HAS (list 5)