title: Stop repeating values Excel 2013 Pivot Table
body: <p>I am having a problem getting Pivot Tables (created from a PowerPivot model) presenting repeating data values where I am not expecting data.</p>
  
  <p>To simplify the model, I am attempting to describe it below (since I am unable to post images here):</p>
  
  <p><strong>Table 1</strong></p>
  
  <ul>
  <li>Columns: Org, Org Name</li>
  <li>Row 1: H, Human Resources</li>
  <li>Row 2: S, Sales</li>
  <li>Row 3: M, Marketing
  <img src="https://i.stack.imgur.com/S94aB.png" alt="enter image description here"></li>
  </ul>
  
  <p><strong>Table 2</strong></p>
  
  <ul>
  <li>Columns: Application, Org Name</li>
  <li>Row 1: bizPaycheck, Human Resources</li>
  <li>Row 2: bizLeads, Sales</li>
  <li>Row 3: bizProducts, Marketing</li>
  </ul>
  
  <p><img src="https://i.stack.imgur.com/Fdkia.png" alt="enter image description here"></p>
  
  <p>I took the data into PowerPivot where I then created a Pivot Table based on my data set.</p>
  
  <p><strong>Selected Fields in Pivot Table</strong></p>
  
  <ul>
  <li>Table: 1, Column: Org</li>
  <li>Table: 2, Column: Application</li>
  </ul>
  
  <p><img src="https://i.stack.imgur.com/mRQDZ.png" alt="enter image description here"></p>
  
  <p>I'd like to filter on all applications for Org: H. Instead, the Pivot Table presents the data like below:
  <img src="https://i.stack.imgur.com/ALXn7.png" alt="enter image description here"></p>
  
  <ul>
  <li>Columns: Application, Org</li>
  <li>Row 1: bizPaycheck, H</li>
  <li>Row 2: bizPaycheck, S</li>
  <li>Row 3: bizPaycheck, M </li>
  <li>Row 4: bizLeads, H</li>
  <li>Row 5: bizLeads, S</li>
  <li>Row 6: bizLeads, M</li>
  <li>Row 7: bizProducts, H</li>
  <li>Row 8: bizProducts, S</li>
  <li>Row 9: bizProducts, M</li>
  </ul>
  
  <p>Can anyone provide perspective into why Excel is assigning values for all Orgs to all Applications?</p>
  
  <p>Any help is appreciated.</p>
  
  <p>Thanks!</p>