title: Pivot Filtering/Calculated Field
body: <p>Let me get strict to the point. I'm trying to filter Piv. Values in my Table - after few hours I realized, that I don't know how to do it by myself.</p>
  
  <pre><code>Month |People| Pass
  -------------------------
  05-'12| 123  | 10     
  06-'12| 33   | 3      
  07-'12| 555  | 4      
  08-'12| 123  | 13     
  09-'12| 23   | 5
  </code></pre>
  
  <p>This is an example of Piv.Table. Rows stands for Years(months) when test was done, People is an amount (Count) of tests done overall and Pass column is amount of tests which result Was above some value. </p>
  
  <p>Now - I'd like to have in a column percentage amount of people whom results were above some value. First of all i tried to create <strong>"Pass"</strong> column from Pivot level. I was wrong. Tried many times to create some Calculated Fileds (with IF, COUNTIF (most accurate) etc.) to extract the number of people (<em>Count</em>) whom pass the test from <strong>"People"</strong> - I store the results of the test in my source table there, in pivot use <em>Count</em> instead of <em>Sum</em>. Unfortunately, either it's not possible or just don't know how to do it. </p>
  
  <p>But let's leave the <strong>"Pass"</strong> , I've created some column in ma source data, that do the trick. What i want the most is percentage amount of people whom pass the test in certain month - in other words, 200 done the test, 100 pass it and, obvious, 50% is the result what I want to get OR  <strong>"Pass/People *100%"</strong>. </p>
  
  <p>That's all. Sorry for the amount of text. I forgot to mention, i need it to create pivot chart and will use it many times. Thats why don't want to do it manually.
  Thanks for any thoughts, help and ideas. Cheers.</p>