Try changing your "Limit Month" calculation to this, and select Y in filters:
IF DATEPART('month',[Date])<[Hide Months] THEN
Hope that helps.
I have to use the index because I am showing the cumulative value at the end of June (220) as a reference line in the black box window. Any suggestions on how to circumvent around this?
One way to get the result you are looking is to add your INDEX() logic inside an RUNNING_SUM() with an IF THEN END Statement
Something like this
When you added to the view you'll see that the running sum re-start with your selection
I attached .twbx file for your reference
Let me know if this helps
Running Total Sum-Copy.twbx 20.1 KB