I just read that it is not possible to use groups in a calculated field.
There's a workaround consisting on creating a calculated field that would group the initial ones though.
It just partially answers the problem because, on doing that I restrict myself from using the embedded group functionnality of drilling down with the little cross.
If anyone has a better solution than that or can confirm that what I want to achieve is not doable, that'd be great.
Please consider voting: Use ‘Groups’ in Calculated fields | Tableau Support Community
I won't say what you want to do isn't possible, because there's almost always a way in Tableau. It just sometimes requires clever workarounds, or pre-processing of the data before it gets to Tableau.
Have you looked into using Sets instead of Groups? http://community.tableau.com/thread/126944 I think you'll still find limitations, similar to using a calculated field.
Another option is to create the groups inside your data source. I realize that's not what you want, but it can make life a lot easier if its possible.
Well, the result I want to achieve involves the use of the dynamic deployment on the axis (which seems to only be herited from the groups).
From what I understood so far, it cannot be achieved neither from sets nor calculated fields as those would only give a static view, right?
Why would embedding the grouping in my data source would allow me to use the drill down ?