So if you think about this, the ONLY way I can see to get a unique sub-selection whereby you could get ALL values for A, and only the Y and Z values for B and C: join the 2 fields to keep a unique combination. Either use Tableau's native Combine Fields option, or create a calculation that is:
[Status] + ' - ' + [Situation]
This should give you a list of fields that are something like:
A - W
A - X
A - Y
A - Z
B - W
B - X
Certainly more tedious, but if you want to allow truly dynamic selection from each of these lists, and you don't know what your user is likely to want, that's the approach I'd go with. If you can predict the few selections I'll make (let's say limited only to the combinations in your example), this would be something like:
IF [Status] = 'A' THEN 'A'ELSEIF [Status] = 'B' OR [Status] = 'C' THEN [Status] + ' - ' + [Situation]
Hello, thank you for your feedback, i tried to create a new dimension with the suggested calculation.
I received the following error message:
"impossible to combine agregation arguments with non agregation arguments within the function"
When i tried to create a new dimension to concatenate the 2 fields i got the same:
[Statut]+ ' - ' + ATTR([Database2(ExportFile)].[Situation])
Is it linked to the ATTR function ?
Thank you for your support