title: Tableau table filter for one column only in table
body: <p>I have a really basic question that I can't figure out. I need to create a table that has multiple calculated fields, but I need only one of the calculated fields to be filtered for a specific dimension value. For example, I have the following data set (dummy data) and I want to create a table that will include total clicks for both companies, but [cost per click] from one company only, company B. </p>
  
  <p>DATA SET</p>
  
  <pre><code>Company| Clicks| $ Cost
  ------------------------
  Comp A | 100   | $20
  Comp B | 200   | $40
  </code></pre>
  
  <p>WHAT I'M LOOKING FOR</p>
  
  <pre><code>       CLICKS | COST/CLICK
  TOTAL   300   |  $0.13 
  </code></pre>
  
  <p>$0.13 comes from 40/300; $40 from company B and 300 clicks from both company A and B.</p>
  
  <p>How do you create a table that has multiple calculations but with one of those calculations filtered on one dimension value only?</p>