Matrix with Date Columns and Tooltip with Date Range

I would like some help with a custom tooltip for a matrix.  I've seen this question asked in different ways, but not quite like what I am looking for.

I have a matrix with several row headers (#, Metric, Measurement, Goal), and column header is a Date field.  The value in the matrix body is a metric value (number).  I am looking to add a tooltip that shows a clustered column/line chart combo that shows displays the metric values over a date range ( previous six weeks this year, and previous six weeks last year).

I have the clustered column/line chart set up on a tooltip, but when the matrix is linked tooltip, the tooltip is sliced by all column and row headers, leaving my tooltip with a single bar and a dot from the line graph.

Is there a way to expand the date range to match my tooltip (maybe slice by row headers but not column headers)?  I've tried different filters on the tooltip, but I feel like the issue is with the matrix.

Thoughts?

Screenshot - Basic Matrix

Screenshot - Basic Matrix and tooltip sliced by row headers AND the single date field

Screenshot - what the tooltip shoud look like for the date above.  Clustered column/line chart sliced by row headers, but with 6 week range.