If the accounts that have completed the activity during January total 100, and then the accounts that complete the activity in February total 100, but some of those accounts repeated the activity, I only want to count the Accounts once for the total cumulative view. So, for example, the total after February wouldn't be 200 but rather maybe 143, if 57 accounts repeated the same activity in February.
My thought was that a Cumulative view of a report on a Count Distinct of Account Name would show me what I want, but the same accounts are being counted twice:
I confirmed this by exporting the results and pivoting to count the number of Account Names, which should be 1940 for March 2018 in this example.
Has anyone created anything similar to this report? Any ideas for tracking a cumulative count of accounts over the course of the year?
