title: Custom field calculation on a pivot table using external data or range in other sheet
body: <p>Hi i want to create a custom calculated field in a pivot table.</p>
  
  <p>I have a table on <strong>Sheet2</strong> named <strong>tblPerson</strong>.</p>
  
  <p>And my datasource for my Pivot Table is in <strong>Sheet1</strong></p>
  
  <p>Like this:
  <img src="https://i.stack.imgur.com/OTGq7.jpg" alt="Pivot_Table"></p>
  
  <p>and my table: <img src="https://i.stack.imgur.com/dxQV1.jpg" alt="tblPerson"></p>
  
  <p>I want to use the data from tblPerson on my Pivot Table, like this:
  <img src="https://i.stack.imgur.com/LDgVR.jpg" alt="dialoguebox"></p>
  
  <p>Does any one knows how to link that information or how to use it on my Pivot Table???</p>
  
  <blockquote>
    <p>Note: I know that this question is similar to this <a href="http://goo.gl/PnQhls" rel="nofollow noreferrer">Question</a>,  but in this case i want to link a table.</p>
  </blockquote>