title: Excel pivot table: How to hide Base Item when showing values as "Difference from..."?
body: <p>I'd like to create a pivot table with values presented as a difference from a specified Base Item. However, I'd like to hide Base Item itself, as it adds redundant empty space to a table.</p>
  
  <p>Picture showing what I'm looking for:
  <a href="https://i.stack.imgur.com/IsYSB.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/IsYSB.png" alt="Desired result"></a></p>
  
  <p>Is it doable? I'm looking for a solution that <strong>does not require</strong> hiding worksheet rows or using VBA macro.</p>
  
  <p>Also, <strong>I'd like to refrain from adding aditional columns to source table</strong>.</p>
  
  <p>Note: filtering out Base Item results in #N/A error as seen below:</p>
  
  <p><a href="https://i.stack.imgur.com/JVQIt.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/JVQIt.png" alt="enter image description here"></a></p>