Longevity by category?

Steven Koplin

I've been asked to create a report giving something like the following: Total # of members in category (by Fiscal Year) Total # of years of membership (all years/all this category members) Average number of years (for this level member) For example: Contributing 419 Members 3871 total years 9.23 years membership average Is there a canned report similar to this? If not, I'd appreciate any advice on how to approach it. Thanks. Steven

Grace Strother

Steven Koplin:
I've been asked to create a report giving something like the following: Total # of members in category (by Fiscal Year) Total # of years of membership (all years/all this category members) Average number of years (for this level member) For example: Contributing 419 Members 3871 total years 9.23 years membership average Is there a canned report similar to this? If not, I'd appreciate any advice on how to approach it. Thanks. Steven

 Hi Steven. There isn't a canned report that would give you this information. Your best bet is to do a membership export to export information for every membership that meets your criteria. Since membership exports export one row per membership, you would then need to use Excel to calculate totals and averages. A custom report built on the exported data could help present the information in a more readable fashion.