title: How to sum the same field twice, but with different sum criteria in pivot tables?
body: <p>What I am trying to do seems to be very easy, but I can´t figure out yet how to do it.</p>
  
  <p>Supposing that I have the following dataset:</p>
  
  <p><img src="https://i.stack.imgur.com/ckMSN.png" alt="enter image description here"></p>
  
  <p>All I want is to see the sum of old sells and new sells, plus the percentage of difference.
  It would be:</p>
  
  <p><img src="https://i.stack.imgur.com/ba8Cn.png" alt="enter image description here"></p>
  
  <p>But it seems that I can´t insert this % column in the pivot table.</p>
  
  <p>If I put the data like this, I wouldn't have the % column.</p>
  
  <p><img src="https://i.stack.imgur.com/gPUeb.png" alt="enter image description here"></p>
  
  <p>So I was wondering if I can use the VALUE field twice, but for the first one tell it to only sum the values that are of type "Old" and for the second one only values that are of type "New"?</p>
  
  <p><img src="https://i.stack.imgur.com/fMCBz.png" alt="enter image description here"></p>
  
  <p>I didn't find anything in field options about criteria so I don't know if it's possible.</p>
  
  <p>Oh, and I tried with Calculated Fields, something like:</p>
  
  <pre><code>=IF(OldNew = "Old", Value , 0) &lt;-- For Old Values Sum.
  =IF(OldNew = "New", Value , 0) &lt;-- For New Values Sum.
  </code></pre>
  
  <p>But it didn't work either.</p>
  
  <p>Thank you!</p>