So my colleague Ravi Mistry posted a blog a fair few months ago now, giving a neat tip to increase the maximum number of levels of columns and rows within a table type view.
He hinted at a tip about hacking the XML to have greater than 16 levels, here I am giving him a post to refer to.
- Go to ‘Analysis’ on the top tool bar, navigate to ‘table layout’ and then ‘advanced’, a table options menu will appear
- Here you will see a ‘Maximum level of column labels’, by default this is set to 6 (and you can only set a maximum of 16. In order to make this value visible in the xml we need to change it from the default value, I will set it to 16.
- Save your file as a .twb file
- Open the .twb file in a text editor, in my example I will use notepad
- Find the line of xml that defines the maximum level of rows (which actually relates to column headers), it looks something like…
<format attr=’row-levels’ value=’16’ />
- Amend the placeholder value we gave by amending the maximum number of column levels value, in my case 16, with the number of columns you want in your table, I’m going to put 17.
- Save the file
- Open the tableau workbook and build out your 17 column (or however many you wish) table
Of course you can do a similar trick with the ‘maximum number of horizontal row labels’ and ‘maximum number of column labels’ by just amending the default value to ensure the value is assigned in the xml and then finding it and changing it accordingly.