PSDio IQ - All Families and Their Diocesan Lifetime Giving

This article is to help you build a query that will get you all families and their lifetime giving. This query will exclude non-givers since we are looking for giving history and this will already be a lot of data for the system to pull. 


First, you will want to add your columns, starting with Contributions - Family DUID, followed by the SUM of contributions which I have renamed as 'Lifetime Giving'. See below for other columns/renaming of columns you can choose. 



I also added Organizations Name and sorted by that to have an organized list of data. 



Finally, I added a condition stating the contribution amount should be greater than 0.


Have more questions? Submit a request



Please sign in to leave a comment.