Not sure i even titled this correct as unsure of the articulation of the problem in a small statement, but here goes!
So, I've got members and month periods and each member will show up as being associated with those various month periods. I want to count from how many times each member is in a particular month along with the total amount of times they showed up in previous months..
So, if i have data detail
Member Period
A Jan
A Jan
A Jan
A Mar
A Mar
A Apr
And each month previous to the last month will include all months prior to it, so in this example, Apr has Apr, Mar and Jan; Mar will have Mar and Jan and Jan only Jan; so the results i get will look like:
Member Period Count
A Jan 3
A Mar 5
A Apr 6
Thanks for any assistance!