title: Tableau filter values instead of aggregate
body: <p>I have the following sample data</p>
  
  <pre><code>Origin       A,  A,  A,  A,  A
  
  Destination  C,  D,  E,  F,  G
  
  Distances    5,  6,  7,  8,  9
  
  Revenue     20, 25, 40, 55, 60
  </code></pre>
  
  <p>What I want to do is filter out all destinations with distances 7 or greater and display the aggregated results in one row.</p>
  
  <p>What I can do so far is get this table:
  Origin:  A, A
  Destination:  C, D
  Revenue:  20, 25</p>
  
  <p>What I want is to display the following table with the Origin and the Sum of the Revenue:
  Origin:  A, Revenue:  45</p>
  
  <p>When I apply the filter on Distance, I set it to be At Most 6, which works when I have 'Destination' in the Columns field, but when I take 'Destination' out, then the filter applies itself to all the distances aggregated (35), which would then filter out everything.  </p>
  
  <p>How can I get the filter to filter on individual values instead of the aggregate?</p>
  
  <p>Thanks for your help!</p>