title: Sum distinct values in Tableau
body: <p>I am trying to sum distinct values (highlighted ones) in Tableau 10.5. Here is the picture how my table looks like</p>
  
  <p><a href="https://i.stack.imgur.com/JkylX.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JkylX.jpg" alt="enter image description here"></a></p>
  
  <p>This is what I want</p>
  
  <p><a href="https://i.stack.imgur.com/5TmaC.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/5TmaC.jpg" alt="enter image description here"></a></p>
  
  <p>This is what I have tried and I am getting</p>
  
  <pre><code>{ FIXED [Cd Year], [Supplies]  : SUM([Quantity]) }
  </code></pre>
  
  <p><a href="https://i.stack.imgur.com/vn9p0.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/vn9p0.jpg" alt="enter image description here"></a></p>
  
  <p>Thank you</p>