Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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.