title: Excel Pivot Table difference in columns of "shown as" values
body: <p>Is there a way to let a pivot table calculate the difference between 2 columns automatically when the values are shown as a % of the parent column total?</p>
  
  <p>Now I need to to manually but the table is dynamic and number of competitors may vary. Function seems so easy but can't find it after googling etc...</p>
  
  <p>See example picture below of what I want to achieve.<br>
  (Column F automated by the pivot table is the goal)<br>
  <a href="https://i.stack.imgur.com/38pf2.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/38pf2.png" alt="Column F automated by the pivot table is the goal"></a></p>