If my understanding is correct you are trying to show Level 2 Values if ALL is select and "Level 3" values if induvidual "Level 2" Value is selected.
I am not sure if this is the most efficient way to achieve this.
I have created a union of the same data set. Attached is the excel and the tableau workbook that I have created.
I have two created two calculations to get there:
Hope this answers your question.
Take a look at this viz by Joshua Milligan - I think it does what you want it to do - i.e. if you select somebody at level 2 (Vader, Thawn or Tarkin), the viz changes to display the level 2 selection, and the level 3 data (as a bonus the drop down filter also changes to reflect your selection).
Is this what you are looking for ?
Should there be a link to the Viz? I can't see / click it.
I have resolved the problem as follows:
1. I have a Parameter that allows me to select my Level 2 Business Unit. There is an "ALL" option included.
2. I have a calculated field that is purely to filter the primary worksheet:
IF [BU Selection]="ALL" THEN 'True'
ELSEIF [Level 2]=[BU Selection] THEN 'True'
The filter is then to set to 'True'. If BU Selection ="ALL" is selected, no filter is applied. Otherwise the value for BU Selection is the filter
3. I have another calculated field that sits on the row shelf to drill down by the appropriate level:
[BU Selection]="ALL" THEN [Level 2]
ELSE [Level 3]
When making a selection on the parameter - All of the linked worksheets change accordingly
Hope this explains it well.
Good to know that you found the solution.
If I understand correctly your parameter has "ALL" and all the business units under level2.
If yes, that was my initial thinking as well. The downside of that is if the values change in Level2, you may have to update your parameter manually and doesn't change dynamically.