Answer

Step 1 - Create the calculated fields

1. Select Analysis > Create calculated field
2. Name the calculated field "Set Date"
3. Enter the following formula and click OK: 

   {FIXED [Product Name] :
   MAX (IF [Order Date] = {FIXED [Product Name] : MAX ( [Order Date] ) } THEN [Sub-Category] END)}

4. Select Analysis > Create calculated field
5. Name the calculated field "Subcategory Value by Date"
6. Enter the following formula and click OK: 

   INT([Set Date] = [Sub-Category])

Step 2 - Build the view

1. Drag "Sub-Category" and "Product Name" to Rows.
2. Drag "Subcategory Value by Date" on Text.
3. Drag Order Date to the Filter shelf and select "Individual Dates"
   1. Right click the date filter and select Show Filter
   2. Set the filter as desired. In this example, the filter is set as a Single Value (slider) filter. 
4. Right click the date filter once more and select Add to context.

Additional Information