for someone who is unable to utilize None , click on your column name in table (e.g dimension selector lvl-1 in video) and select hide field labels for rows
It’s a great video I have one question Suppose if I have more than 100 columns and I wanted to have same thing which you have shown in the video, how can I achieve? One more thing instead of having 3 parameters, can we have 1 parameter with multi select of dimensions
I believe Tableau has a limit on the number of columns you can have in a table. A quick Google search would be able to check that. Also, a table with 100 columns wouldn't be readable so you'd be better off building it using SQL as a view or using something like dbt, and then making it accessible within the database to end-users. Yes, you could go with 1 parameter which allows you to switch between dimensions. This is the classic approach. My method is a bit more advanced. Thanks for the questions. -Justin
If you only wanted one column then instead of switching the values in the column, you could instead use "sheet swapping" and create different sheets for each value you would show. In the case of "none", the sheet wouldn't have a column at all. This would get increasingly complicated if you wanted to not show a column at all but wanted more than one column in the table.
![Enhance your Tables in Tableau [A Step by Step Guide]](http://i.ytimg.com/vi/cr7lxMGr2D0/mqdefault.jpg)
for someone who is unable to utilize None , click on your column name in table (e.g dimension selector lvl-1 in video) and select hide field labels for rows
It’s a great video
I have one question
Suppose if I have more than 100 columns and I wanted to have same thing which you have shown in the video, how can I achieve?
One more thing instead of having 3 parameters, can we have 1 parameter with multi select of dimensions
I believe Tableau has a limit on the number of columns you can have in a table. A quick Google search would be able to check that.
Also, a table with 100 columns wouldn't be readable so you'd be better off building it using SQL as a view or using something like dbt, and then making it accessible within the database to end-users.
Yes, you could go with 1 parameter which allows you to switch between dimensions. This is the classic approach. My method is a bit more advanced. Thanks for the questions. -Justin
this is great, but is there a way to have the column not show at all if you select "None" in your parameter?
If you only wanted one column then instead of switching the values in the column, you could instead use "sheet swapping" and create different sheets for each value you would show. In the case of "none", the sheet wouldn't have a column at all.
This would get increasingly complicated if you wanted to not show a column at all but wanted more than one column in the table.