I'm trying to sum the running accumulated balance over periods in a ValueList Dimension (please see the attached sample file). When using the RangeSum in other cases it works perfectly. But maybe because the dimensions are the Valuelist itself in addition to the MonthYear dim so that adds a bit complexity.
I thought about using aggr function but couldn't figure out how to use the Valuelist as a dimension in the aggr. Not even sure if that will work.