title: Excel Charts for table with many duplicates
body: <p>I have a list of names with 1000 entries and maybe 750 unique.  There are other attributes, like location and position.  Can I create a pivot table that would show me simple stat's like X number of unique people, X number unique in location 1, location 2, location 3, and finally x number of positions in location 1, position 2/location1, position 3/location2...?</p>
  
  <pre><code>Name    Location    Title
  Smith, Bob  UK  Sales Manager
  Smith, Bob  UK  Plant Manger
  Jones, Keith    UK  Sales Manager
  Jones, Keith    UK  Plant Foreman
  White, Derick   Denver  Sales Manager
  Brown, Frank    Boston  Supply Chain
  Black, Jay  Denver  Sales Manager
  Smith, Jeff Denver  Sales Manager
  Gonzalez, Al    UK  
  Gonzalez, Al    UK  Staging Area Manager
  Bright, Susan   Denver  Legel Secretary
  Bright, Susan   Denver  Paralegal
  Bright, Susan   Denver  Executive Assistant
  Bright, Susan   Denver  Press Secretary
  Alf, Jeff   Denver  VP, Sales
  Green, Burt Boston  VP, Sales
  Jones, Chuck    Denver  Plant Foreman
  Alten, Cory Denver  Sales Manager
  Clark, Jerry    Boston  Plant Foreman
  Romo, Tom   Denver  Sales Manager
  </code></pre>