This content has been marked as final.
Show 1 reply

1. Re: Total count of consecutive yearly order (by customer)
Jennifer VonHagel May 6, 2018 9:33 PM (in response to Yichuan Yu)Hi Yichuan,
This is a brute force method of calculation that works only when 4 years are in play. This kind of problem should be good for a table calculation, because we can evaluate along any number of years for each customer to get an answer; however, it is difficult to then use a table calculation as a dimension against which we can count distinct customers.
So this calculation just looks at each possible combination of results  again, it works only for data that has up to 4 years to check for.

Consecutive Years.twbx 388.6 KB
