title: How to create a calculated field that references a cell value in an excel pivot table
body: <p>I have my data that looks like the following:</p>
  
  <pre><code>Col1 | Value
  A    | 1
  B    | 1
  A    | 3
  C    | 7
  </code></pre>
  
  <p>and a pivot table that sums up the values for col1.
  In addition I have an exchange rete in a another cell (in another worksheet)  and I would like to create a calculated field in my pivot table that multiplies the Value for the exchange rate in that cell.
  Is this possible? How?
  The reason for this is that the users might change the exchange rate in the cell but they would not know how to change it in the calculated field.
  I know that I can simply add a column in my source data with the calculated value, but I would like to do it as calculated pivot table field if this is at all possible.</p>