Hello there Mark Fisker,
I took a look and was able to calculate the WINDOW_SUM of the first measurement, but had to include it as a row (without doing some other workaround like using a separate sheet, etc.). Hopefully this will help you get started (you could just throw it on the Tooltip instead of showing it as a row).
For question #2 on ranking, do you want the rank to be based on the total calculated above? If so, try creating a new calc, like RANK(Above Window Sum Calc) and see if you can get that to provide the results you want based on it's scope and direction ("Compute Using"). I've added an attempt as another row in the attached 10.5 TWBX
Best of luck and happy analyzing!
1 of 1 people found this helpful
Thank you Matt,
That did the trick!!!