title: How Can I Show Count Of 2 Column Values Into A Pivot Table With Grouped Values As Rows?
body: <p>I have a data table in Excel simplified as below.</p>
  <p><a href="https://i.stack.imgur.com/11FXB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/11FXB.png" alt="Raw Data" /></a></p>
  <p>I am trying to make a Pivot Table as below, with Week Data expected to grow each week.</p>
  <p><a href="https://i.stack.imgur.com/piZUo.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/piZUo.png" alt="Pivot Data" /></a></p>
  <p>Current Pivot Table uses Data Models, so I believe I am limited to Measures and no Calculated Fields (correct me if I am wrong).</p>
  <p>I have tried creating 2 Data Models and create a relationship based on Week, but it is not allowed since the values are not unique. Getting the Items Sold count might be the missing piece I need. I think Inventory column should be solved by creating a measure to find the difference between Items Added and Items Sold.</p>
  <p>I have been pulling my hair out trying to solve this. I feel it should be possible, and I am just missing the obvious solution in front of me.</p>