I have a data table in Excel simplified as below.
I am trying to make a Pivot Table as below, with Week Data expected to grow each week.
Current Pivot Table uses Data Models, so I believe I am limited to Measures and no Calculated Fields (correct me if I am wrong).
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.
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.