First we want to create a selection for the last fiscal year's donors:
  1. Go to Analysis > Information Library 
  2. Click Add an ad-hoc query 
  3. Select the source view of Constituents
  4. In the left column, highlight Revenue. In the middle column, drag Date into Include Records Where and set this to be your last fiscal year.
  5. Next, you will want to tell Altru what you consider a donor. To find everyone who made a donation, expand Revenue in the left column. Under Revenue, highlight Application Details. In the middle column, drag Application to Include Records where. Set this to be equal to Donation.
  6. On Set Save Options, Create a selection and check to Show this Selection in the Query Designer
  7. Save and close
Here is an example of how this selection might look:
User-added image

Next we want to create a query to exclude all donors from the selection:
  1. Click Add an ad-hoc query
  2. Select the source view of Constituents
  3. In the left column, highlight Revenue. In the middle column, drag Date into Include Records Where and set this to be your entire date range.
  4. In the left column, highlight Selections. In the middle column, drag the Selection created above into Include records where and set this Equal to No.
  5. (Optional) If you're looking to only find donors who made a gift over a certain amount, in the left column with Revenue still highlighted, drag Amount from the middle column to Include Records Where. Set this to be equal to the amount that you're looking for. Note: This field will return anyone who has made a single gift that meets your amount criteria. If you'd like to create a list of donors who have cumulatively given more than a specific amount, see our related solution: I need to pull a report that shows all donors who donated a cumulative amount for a certain time period
  6. To find everyone who made a donation, expand Revenue in the left column. Under Revenue, highlight Application Details. In the middle column, drag Application to Include Records where. Set this to be equal to Donation.
  7. (Optional) If you'd only like to find donors who made a gift to a specific designation, with Application Details still highlighted in the left column, from the middle column drag Designation System Record ID to Include Records Where. Set this to be equal to or one of the designations that you're looking for.
  8. Save and Close

Here is an example of how this final query might look:
User-added image