Slicer Selection

Hi All,

I'm look for some assitance with a report I'm working on. I've enclosed a brief simplified example of what I'm trying to achieve.

I have 2 tables

1 - CourseDimension

2 - CourseFact

Ideally I would like a report to use a slicer (set to single selection) for Coursecode e.g Select BR0001A andthen the report produces 2 matrix that look like the below (the first matrix is straightforward)

Matrix 1 - 

Matrix 2- Although the slicer selection is selecting BR0001A I need the report to pull through all Courses that are set to same level as the selected course, in this case level 1.

I hope this makes senses. Any assitance/best practice advice would be greatly appreciated.

Thanks