Not the most elegant solution, but then I'm only on my first cup of coffee:
IF INDEX()<=5 THEN WINDOW_SUM(SUM([Sales] ),0,5-INDEX() )
ELSEIF INDEX() > 5 AND INDEX() <= 10 THEN WINDOW_SUM(SUM([Sales] ),0,10-INDEX() )
(See attached) There's probably a better way to do this so the 5, 10 aren't hard-coded. I'll think about it on my flight home.
Book2.twbx.zip 948.0 KB
Hmm...does not seem to work for me
Shawn...I am using the formula you provided and it works fine....However though the rows have correct values...the subtotal is not computing correctly.
Need you help with the subtotal computation.