I am looking to create a lapse donor report for our development team. I am close, but the cross filters aren't applying as well as I thought. I am getting the same person multiple times, and definitely have donors who aren't "lapsed" appearing in the report. Any ideas?
2 respostas
What we usually do for those sorts of things is use the metric fields in Apsona to get multiple columns with totals by FY for however many FYs you need, and then use calculated fields to create flags (lapsed is something like: if current FY is 0 and prior FY > 0 then true)
