Week on Week trend chart

[#1]

Hi,

I am looking to create a trended chart which shows weekly sales and the % Change of sales Week on Week.

I can't figure out how to create my second measure which is offset by a week.

i've attached what i am trying to do using Excel.

hopefully someone can help

thanks

[Gysbert_Wassenaar]

See attached example.

[#3]

That looks pretty awesome, but it looks like you just loaded up some data that was already flagged as previous week.

what i need is a way of working out the previous week on the fly.

so this week is: sum(sales)

previous week, something like: sum(<offset(week-1)> sales)

but i have no idea on the syntax. Any ideas?

[#4]

Legend! Thank you sir!

[#5]

actually not 100% correct i am afraid....so close!

Functionally it works, but the first x days are not filled out.

so, if the function is above(sum(sales),7) at the day level the first 7 days are blank. This is true when you start drilling into the chart too.

attached is the original sample but with the functions added. you can see the first slot in the chart is always blank.