Hi all!
I am trying to organize member data. I need to see how many active and inactive members we have year over year. These categories are complex.
"Active" members include people who have shopped that year (measured by one column that includes all dates they have ever shopped), and who are either active on their yearly payments (measured by one column that indicates the date of their last payment) or who are lifetime members who already reached the cap on their yearly payments (measured by one column with a dummy variable - 0 for not a lifetime member and 1 for a lifetime member).
"Inactive" members would include people who haven't shopped that year and/or are behind on their payments, and who have not cancelled their membership (measured by a couple columns with dummy variables - 0 for not cancelled and 1 for cancelled).
I want to see this data year over year - how many active and inactive members did we have in each year from 2010 to present? The only ways I can think of to accomplish this would be extremely time consuming and would have to be repeated at the start of every new year, which is not ideal.
Is there an (at least somewhat) easy way to set this up?
Thanks in advance!
