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!