I am trying to create a list of constituents that gave us over $5000 during a particular period time and include their name, address and the total that they gave during that period. I'm having trouble trying to get the Total Giving in my output set. Am I using the wrong approach or there an easier way to tackle the question?
Hi Kelly, is the issue that it's putting each individual gift for a constituent in that time on separate lines rather than summing the total (so if I gave you a $50 gift in October, a $200 gift in December, and a $100 gift in March it's listing those each as their own line rather than combining them into one line showing $350)? I just want to confirm the issue you're seeing.
That would actually be fine, but its returning all donations that the donor has ever given.
I see! In your output set you should be able to go to Output Filters and filter that output element by Contribution Date. Is that not an option that's appearing for you?
You are absolutely right! I thought about that same thing on my home last night. Thanks for the input!