I'm having a lot of trouble stopping Tableau from nesting dimensions in worksheets I'm trying to build. I'm trying to build a large crosstab sheet, but instead of nesting the dimensions, I want the dimensions stacked as separate blocks. For example, if I put the fields "Category" and "Region" in a row, it nests Category within Region. I would rather have Category and region be separate, un-nested blocks.
For example, this is what I want my crosstabs to look like:
But this is how Tableau formats it through nesting:
Can anyone help me solve this problem?
The best way around this would to create several worksheets and place them on a dashboard together. There currently, is no way to get the desired view all on one worksheet. This might be a good one for the Ideas section.