Hello Experts,
I think its a basic query, but still tough as I am new to this. I have a chart which shows sales vs forecast for 52 weeks. However the requirement is this needs to be rolling 52 weeks, as in currently in week 10 for 2011, then the chart should show backwards till the week 11 for 2010, how can I achieve this?? Currently I have a Year Week field which has the format of 200901. How do I match it to say I want Current Week - 52 Weeks data at anytime?
Thanks Again
