title: Excel pivot table sum distinct values
body: <p>I have a question to ask about summing distinct sums. I have a table as below which is coming from a database</p>
  
  <pre><code>ID  |Activity |Rank| Max Rank|Health    Aggregated_$    Tiering   Engaged   Quarter
  1   |Activty3 |3   |8        |1            100         4 - Lowest   Y   FY18 Q4
  1   |Activty3 |3   |8        |2            100         4 - Lowest   Y   FY18 Q1
  1   |Activty4 |4   |8        |1            100         4 - Lowest   Y   FY18 Q4
  1   |Activty2 |2   |8        |1            100         4 - Lowest   Y   FY18 Q3
  1   |Activty8 |8   |8        |1            100         4 - Lowest   Y   FY18 Q3
  </code></pre>
  
  <p>I am trying to get the sum distinct $ in each activity. Therefore, what I am trying to achieve is something like this in a pivot. The reason why I have to use the pivot is because Quarter is used as a filter to get only certain  quarters (FY 18 and beyond for example)</p>
  
  <pre><code>Activity  |   100
  Activity2 |   100
  Activity3 |   100
  Activity4 |   100
  Activity8 |   100
  </code></pre>
  
  <p>My pivot looks like this now. Was wondering if a sumproduct would work on this? </p>
  
  <p><a href="https://i.stack.imgur.com/pH5Mx.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/pH5Mx.png" alt="enter image description here"></a></p>