I noticed this post hadn't been responded to. Here's a workbook that hopefully meets your needs. I made a couple of changes, one is that I used the Category/Subcategory hierarchy instead of Subcategory/Product because the latter data was too sparse for the calculations to show much of anything. Secondly, I changed the color scheme to red/white/black diverging because red/green doesn't work for color-blind people, and your desired view had shown 3 colors.
I did use a table calculation as a parameter-driven filter on week of Order Date.. Filters based on table calculations are applied after most all calculations are completed, so the filter can effectivel hide data from the view. Also, I had to put the filter calc on the Level of Detail in the view - in Tableau 7.0 table calc filters can only "see" dimensions that are on the Rows and Columns shelves, and since this view requires the Sub-category and WEEK([Order Date]) to be on the Level of Detail, also putting the table calc on the Level of Detail lets the instance of that calc on the Filter shelf "see" itself there and work.
Let me know if this works for you,
Wow thank you for this Jonathan, it works perfectly for me !