Calculations - level down

Content

I need to build three charts that hinge off one another:

1. Average or Median salary by Gender/BU/Management level.

2. From the chart above, I need to just get average/median salary by Management level and Gender.  The thing here is I need to do it from the averages above by BU.

3. Lastly, Need overall breakdown of salary by gender.  However I need it to be based on the averages from the 1st breakout.

 

Is this possible?  When I do the 2nd/3rd chart, I can't find a way to based the calculations on averages by each BU and Management level.