title: Creating Calculated Field with SUM and COUNT of Fields Pivot Table
body: <p>Here's a snapshot of my pivot table.</p>
  
  <p><a href="https://i.stack.imgur.com/I5h6v.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/I5h6v.png" alt="enter image description here"></a></p>
  
  <p>I want to create a calculated field that displays the percentage from the 
  <strong>Responded</strong> column (C) over the <strong>Ticket #</strong> column (B) as in column G.</p>
  
  <p>The <strong>Ticket #</strong> column is a column of value text strings (e.g. 413456, 464313) and the <strong>Responded</strong> column is a list of 1's and 0's. In my pivot table I am taking the count of all Ticket # and the sum of the Responded.</p>
  
  <p>I tried to create a calculated field with the following formula</p>
  
  <pre><code>=Responded/COUNT('Ticket #')
  </code></pre>
  
  <p>but this gave me the same as <strong>Sum of Responded</strong>. How can I create a calculated field that gives me the % in column G?</p>