To get the last 52, 24, etc weeks relative today, a calculated field similar to the following can be created:
if [Order Date]>=DATEADD('week', -52, today()) and [Order Date]<=today() then 'show' else 'hide' end
Depending what the number that is placed in the Dateadd section of the calculation will determine the number of weeks.
Then, place this on the filter and select 'show.'
Hope this helps!
Another challenge came up...what if I want to see on the same table Latest 52 wks, Latest 24 wks and Latest 4 wks for example....so filtering on 1 rolling period does not help...I have attached a workbook and the table I am looking for should be something like below:
2011 2012 2011 2012 2011 2012
L52w L52w L24w L24w L4w L4w
Thank again for your help!
test.twbx.zip 62.7 KB