# of years of giving but not consecutive

Options
I want to know over the history of our organization (41 years), how many years a donor has given in, not the consecutive number of years. Say a donor gave in 2000, skipped 2001, gave in 2002-2008, skipped 2009 & 2010, and gave 2011-2017. A consecutive year report would only show this donor as giving 7 years because that is the last consecutive stretch of giving. I would like to know that this donor has given in 15 different years. The amount or # of gifts in any single year is not important. Let me know if you have a solution. Jacqueline

Comments

  • Jacqueline,

    I have a pivot table I use for this exact thing. PM me your email address and I'll send it over.


    -John
  • John Cioni:

    Jacqueline,

    I have a pivot table I use for this exact thing. PM me your email address and I'll send it over.


    -John

    John - I'd love a look at your pivot table as well - I'll IM you with my email and if you wouldn't mind sending it on that would be great!  Thanks!  Joanne

  • JoAnn Strommen
    JoAnn Strommen ✭✭✭✭✭
    Ancient Membership Facilitator 4 Name Dropper Photogenic

    Jacqueline Kordsmeier:

    I want to know over the history of our organization (41 years), how many years a donor has given in, not the consecutive number of years. Say a donor gave in 2000, skipped 2001, gave in 2002-2008, skipped 2009 & 2010, and gave 2011-2017. A consecutive year report would only show this donor as giving 7 years because that is the last consecutive stretch of giving. I would like to know that this donor has given in 15 different years. The amount or # of gifts in any single year is not important. Let me know if you have a solution. Jacqueline

    If the pivot report doesn't give you all the info you need, you're looking at setting up an Export of each year's giving.  Here's link to last discussion on the subject that I recall.

    https://community.blackbaud.com/forums/viewtopic/159/15420?post_id=48633#p48633

  • John Cioni:

    Jacqueline,

    I have a pivot table I use for this exact thing. PM me your email address and I'll send it over.


    -John

    Hi John,


    I would love a copy of your pivot table if you don't mind sharing. 

    I'll message you. 


    Thank you,

    Michaela

  • John Cioni: Jacqueline, I have a pivot table I use for this exact thing. PM me your email address and I'll send it over. -John


    Hi Joh,

    This is exciting.  May I get this too.

    Thanks,

    Jenny Physioc

    Jenny.Physioc@artcenter.edu
  • John Cioni:

    Jacqueline,

    I have a pivot table I use for this exact thing. PM me your email address and I'll send it over.


    -John

    John,

    If you could attach the pivot table to your post, I think that would help everyone!

    Thanks,

    Barbara

     

  • I've sent it to everyone that has requested it. Just PM your email address and I'll get it over to you.

     

    Barbara Schlichter:

     

    John Cioni:

    Jacqueline,

    I have a pivot table I use for this exact thing. PM me your email address and I'll send it over.


    -John

    John,

    If you could attach the pivot table to your post, I think that would help everyone!

    Thanks,

    Barbara

     




    Thanks!

     

     

Categories