Leadership Metrics

To set this up in a query, you'd want to to a constituent query and go to Summary Information > Summary For Gift > Total Number of Gifts (or Total Gift Amount if you're looking for yearly total and not individual gifts of $10k+ ... couldn't tell which you were talking about from your original post).



If you're doing total number of gifts, then on the Criteria tab, choose "greater than or equal to" and set the value as 0. If you're doing the total amount of gifts, then in the Critera tab, choose "greater than or equal to" and set the value as 10,000.



In the filter tab, select your date range and your gift type. Gift type is super important, because if you don't tell it otherwise, it will count pledges and payments on pledges separately instead of counting one or the other. Same goes for recurring-gift-pay-cash and recurring gift. 



Then, select the same criteria a second time and set up the criteria for a different fiscal year. Make sure this second criteria gets an AND statement instead of an OR statement (it'll default to OR when you select the same criteria multiple times. Just do this as many times as you need to, onece for every consecutive fiscal year you want to search for. 



For your new major donors, I guess it depends on how you categorize "new." The easiest way to do it would be to find the summary for total giving for, say, last fiscal year and limit it by people who gave $10k+, and then do a summary for whatever previous fiscal years you want to limit by and make sure that their total giving is less than $10k in your Criteria tab . 



Does this make sense? Discussing these without pictures can be a little confusing.

The Consecutive Years Report that Christine mentions works great if you are looking by calendar year.  If you are looking by a fiscal year  this report does not work so well. 



I have my query set up very simalar to Ryan's, then I also have an  export that pulls total gift summary by dates in the same manner Ryan set it up in the query.