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.