title: How to switch between two sets of columns in Tableau?
body: <p>I have an Excel doc being used, and in it there are 6 worksheets, each a different company. The data types and names are all the same within each tab.</p>
  
  <p>In Tableau, I have joined all the worksheets and I have a "Companies" dimension, which translates to showing 6 columns on the graph, one for each company.</p>
  
  <p>What I need help with is the following. 2 of the companies are the same, except their data differs slightly on purpose to show that the results are skewed based on outside forces.</p>
  
  <p>In other words, this is what I am working with:</p>
  
  <p><strong>Companies</strong> (from Excel worksheets, joined into a single dimension):</p>
  
  <ul>
  <li>1, 2, 3, 4, 5a, 5b</li>
  </ul>
  
  <p><strong>Set A</strong>: "Correct Results"</p>
  
  <ul>
  <li>1, 2, 3, 4, 5a</li>
  </ul>
  
  <p><strong>Set B</strong>: "Skewed Results"</p>
  
  <ul>
  <li>1, 2, 3, 4, 5b</li>
  </ul>
  
  <p>I need Set A's columns showing on the graph by default, but I need a filter or action that will allow the user to switch the groups, without having to select the companies individually, such as a single-select radio-button style filter with the following:</p>
  
  <p><strong>Choose a Set</strong>:</p>
  
  <ul>
  <li>Set A - On</li>
  <li>Set B - Off</li>
  </ul>
  
  <p>I know this is possible, but I can't decide on the best way to do it.</p>
  
  <p>Currently, I have an Exclude single-select filter on, which will exclude the selected group. The downside is that users can go on to exclude Companies 1-4, which isn't good. It's also confusing to explain to them selecting Company 5a to exclude Company 5a. It's just not intuitive.</p>
  
  <p>Any suggestions?</p>
  
  <p>Here is a link to view what I was currently able to pull, described above:</p>
  
  <p><a href="http://public.tableausoftware.com/views/BMD-Full-Share-of-Voice/Full-Share-of-Voice?:embed=y&amp;:toolbar=no&amp;:tabs=no" rel="nofollow">http://public.tableausoftware.com/views/BMD-Full-Share-of-Voice/Full-Share-of-Voice?:embed=y&amp;:toolbar=no&amp;:tabs=no</a></p>