Add Calculated Field To Pivot Table
<p>I am attempting to add a calculated field to my pivot table that is attempts/success and show that as a percentage.  I followed these steps</p>

<blockquote>
  <p>Click in pivot table<br>
  Press alt+jtjf
  <br>In the window that opens give it a name
  <br>add the formula to use</p>
</blockquote>

<p>The formula I used was <code>=['Stolen Bases']/['Attempts']</code> but all that this did was sum the numbers.  So an example would be Bob's total would be 104 instead of 73.33%.  Below is an example of how I want my pivot table with calculated column to look.  Row Labels, Stolen Bases and Attempts all exist in the dataset but the Total does not that is a calculated field.</p>

<p>How can I add this calculated field column and have it accurately pull the percentage?
<a href="https://i.stack.imgur.com/Eq2u7.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Eq2u7.png" alt="Picture"></a> </p>

<p><strong>EDIT</strong><BR><BR>
One thing that may be causing the issue...the dataset is a sql server query and field setup has structure like so</p>

<pre><code>playername
SBAttempts
Outcome
</code></pre>

<p>So my query to get stolen bases and attempts is</p>

<pre><code>Select playername, 
case when outcome = 'SB' then COUNT(SBAttempts) else NULL end as "Stolen Bases"
case when outcome = 'OUT' then COUNT(SBAttempts) else NULL end As "Attempts"
From baseballstats
</code></pre>

<p>Which leaves my pivot table broken out like so:<br>
Columns = outcome<br>
Values = Count of SBAttempts<br>
Rows = playername</p>