In Tableau it is simple as creating a running total table calculation. There is no arbitrary time limit, and would would there be? It makes no sense. I'm not having much luck creating the previous year aggregations in your solution, I'm also confused as to whether your solution uses the parallel period function or the cumulative period function, or some combination of both.
... View more