I'm not sure if I quite got there, but maybe this can give ideas.
I think it is possible to use Running_Sum(SUM(Sales Units)) in you calculations.
[Calculated Total] would be:
SUM([DC OH])+SUM([Store OH])+[RunningSales]
And the Max would be:
Please see workbook v10.3 attached in the Forum Thread.
Thank you so much for taking the time to answer me and send that example! I really appreciate it. Unfortunately, I cant use table calculations since the view that I will be using this information for does not include week number. When I try to bring in a table calculation I am left with a sum of every instance of that calculation. When I try to do an average I get an error saying table calculations cant be aggregated.
I am going to type up a new post, which should hopefully be a little more concise.