Restricting data based on fiscal week
I have a calculation view based on sql which is source for reporting tool.In the calculation view I have to restrict data based on fiscal week.
the scenario is
1) data should be displayed for 12 fiscal weeks.
past 10 weeks and future 2 weeks based on current fiscal week.
How can we put this in where clause.