The dataset contains selling data from a petrol store.
I want to show the amount of liters starting at current week and then 10 weeks backwards. I thougt I can make a calculated dimension for this; but after trying and searching it still doesn't work.
In my selection I select the Year (ex. 2011) and Week (4). At the top of the tab I show the selling data for the selected week. In the bottom I want to show the selling history for the last 10 weeks including a compare with last year.
I've attached an Excel sheet, maybe that makes my question clear.
Maybe I missed something and is it impossible with Set Analysis?
Contrary to the above; there's absolutely no reason as to why you shouldn't be able to achieve the results you require using Set Analysis or good old 'IF' statements to control the dates the application is looking at.
If you can post a sample of the .qvw that would help as not knowing your data set it's tricky to offer a suitable solution.