Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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.
Any suggestion/tip is appreciated.
Thanks.
I doubt you would be able to use ValueList in aggregate's dimension. An alternative to ValueList could be to use an Inline table which can then be referred to in the aggregate dimension