Retain accumulation after selection

[#1]

Hi Community,

I want to add a new column that Sums the last 4 weeks of Value2.

I used accumulate with 4 step back. But my problem is when I select few weeks Example ,week 5 to week 10, the Accumulated values changes.

Any other solution to do this?

Please see attached qvw to view my sample file.

Thanks in advance!

Ronald

[swuehl · Accepted solution]

Try something like this (without using the accumulation option) as expression:

=aggr(rangesum(above(sum({1}Value2),0,4)),Week)

or

=aggr(rangesum(above(sum({<Week>} Value2),0,4)),Week)

edit:

Week field load order must be in chronological order to make this work correctly.