title: PivotTable duplicates
body: <p>I have some data that I need to find an average day rate for a certain company. The data consists of 1000's of names, some duplicates with a day rate against them.</p>
  
  <p>If I insert a PivotTable and filter on the company, the Average day rate will show, however, I know it is wrong as it is including the duplicate names.</p>
  
  <p>I have got round this by double clicking on the average value and bringing up the data for that company in a new tab. Then I can insert another pivot table to remove the duplicates and then from that, find the average day rate.</p>
  
  <p>Is there a way to by pass having to insert another pivot table, on the filtered tab?</p>
  
  <p>FYI I'm very new to pivot tables.</p>