title: Sum Distinct Category and Value
body: <p>I have the data from SQL like below</p>
  
  <pre><code>Adviser | ProductProvider | NumberPolicyLapsed |Status |
  --------|-----------------|--------------------|-------|
  A       |ANZ              |3                   |New    |
  A       |ANZ              |3                   |Ongoing|
  A       |ANZ              |3                   |Out    |
  A       |AXA              |4                   |New    |
  A       |AXA              |4                   |Ongoing|
  A       |AXA              |4                   |Out    |
  A       |Zurich           |5                   |New    |
  A       |Zurich           |5                   |Ongoing|
  A       |Zurich           |5                   |Out    |      
  </code></pre>
  
  <p>How do I tell Tableau to read the distinct Adviser, distinct ProductProvider, and distinct NumberPolicyLapsed to sum up the column NumberPolicyLapsed? So basically for Adviser A, the Number of Policy Lapsed will be 12 (3 + 4 + 5). </p>
  
  <p>So far, I have tried </p>
  
  <ul>
  <li>Using SUM(NumberPolicyLapsed) and the result is 36 (3+3+3+4+4+4+5+5+5).</li>
  <li>Using LOD {Fixed [Adviser],[ProductProvider] : SUM
  (NumberPolicyLapsed)} and the result is way bigger than 36.</li>
  <li>Using Window_Sum (NumberPolicyLapsed) after re-constructing the table without status but it doesn't work.</li>
  </ul>
  
  <p>I'm using Tableau Desktop 10.0.</p>
  
  <p>Thanks. </p>