
1. Re: How to calculate cumulitive sales on a weekly basis without using table calculations
swaroop.gantela Jul 3, 2018 7:51 PM (in response to Nicholas Zabilski)Nicholas,
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:
WINDOW_MAX([Calculated Total])
Please see workbook v10.3 attached in the Forum Thread.

274688total.xlsx 8.5 KB

274688total.twbx 11.9 KB


2. Re: How to calculate cumulitive sales on a weekly basis without using table calculations
Nicholas Zabilski Jul 10, 2018 1:00 PM (in response to swaroop.gantela)Hi Swaroop,
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.
Thanks again!