Hello,
I'm quite lost right now and out of ideas. Any suggestion would be appreciated. What I'm trying to do is this: I want a straight table with YearWeek as dimension. Then I want one expression to be a sum of sales for the previous 12 months back from the last date of the evaluated week.
I've tried set analysis but since the set is only determined once for every table, rather than once for evey row ,I can't get it to work. How would one go about getting multiple rolling values to be calculated in the same chart?
Thanks in advance,
/David