2 of 2 people found this helpful
You can include a maximum of 16 Columns and Rows in a text table. The default number of Columns/Rows is set at 6. When you exceed 6, as in your example above, it will combine multiple fields together unless you change the Table Layout settings.
To change the Table Layout and increase the number of columns and rows in your table, go to:
- Analysis > Table Layout > Advanced
- Then select the options shown in the screenshot.
1 of 1 people found this helpful
There's no way to display it that way unless you have those fields as a member of a single dimension (i.e., it would need to be in the same column in Excel). Each time you drag a dimension to the rows shelf, Tableau produces a row for each dimension member (not for each dimension). You can't stack separate dimensions on top of each other.
Category is a dimension. Furniture, Technology, and Office Supplies are members within the Category dimension. Tableau creates its rows for the dimension members, not for the dimensions themselves.
You might need to re-structure your data in order to accomplish what you're trying to do.
7 of 7 people found this helpful
More than 16 columns (row headers) in Tableau
As you well know if you are reading this post, Tableau only allows 16 row headers/labels in a single visualization before it starts concatenating the header values. The default is actually 6 headers until it starts to concatenate but this can be increased if you go to the menu Analysis->Table Layout->Advanced
Note 2: If you are using this workaround to be able to display/export larger tables from Tableau, it is not a good idea to treat a Data Visualization application like an ETL tool. You are using Tableau wrong.
Note 3: This is not supported. At all. If something breaks please dont email Tableau Support about it. This hack comes 'as-is'.
Note 4: I think this hack will work if you want to put a few extra columns (maybe like 20 total), but dont go crazy with it and try to put 50 columns out there.
Note: You can only open .twb files to see the XML in a text editor. If you have already saved your file as a .twbx you can right-click on the icon and choose 'unpackage'. This will create a .twb file and a folder with all the excel files/extracts/images/etc that were part of the packaged workbook.
Note: If you go back into Analysis->Table Layout->Advanced it will still say the last numbers you entered in the UI, not the new numbers you manually entered into the XML, just ignore them.
Again, I do not condone this behavior, but sometimes you just need 'a fix'.
This doesn't work for me. I'm using version 9.2.4 and I tried the steps above. I edited the xml in notepad and changed the value to 25. I saved the file then I opened the Tableau notebook normally. I checked the worksheet I had already build that had all of the fields in it. There was no change and I couldn't get all of the fields to display in the worksheet. I also tried adding the worksheet to a dashboard and manually adjusting the fields but it still doesn't work. I then tried building a new worksheet from scratch and it still doesn't display all of the fields that I wanted to see.