Would simply hiding the columns give you the desired view? Perhaps you can create a second calculated field that uses the [Select Week to] and/or [Select Week From] parameters similar to:
if [Week_ID]=[Select Week From] or [Week_ID]=[Select Week to] then 'show' else 'hide' end
Then, place this somewhere on the view, and right click and select Hide where it says hide.
Hope this helps!