title: FileMaker Pro 14 Calculating Pie Graph Axes
body: <p>So let's say I have a table called Work Table:</p>
  
  <pre><code>Name    Program Hours
  John    FDA     3
  Jacob   FDA     4
  John    FDA     2
  John    AHA     1
  Jacob   AHA     5
  Jacob   AHA     7
  Jacob   FDA     8
  John    AHA     12
  </code></pre>
  
  <p>If I were to graph this in a pie chart, it would show each record on the pie chart. The legend would have two spots for FDA and two spots for AHA rather adding them up together. I need them to add up together so that it displays the total hours attributed to FDA for each person in one pie slice, and the total hours attributed to AHA for each person. The "each person" part I have down already with a subsummary part in my layout, but not adding up the third column values when they match in the second column.</p>
  
  <p>I've tried running an ExecuteSQL calculation in each of the fields. For some reason when I try to post them here I get an error and stackoverflow won't let me post the question, so here is an image of the SQL I'm using:</p>
  
  <p><a href="https://i.stack.imgur.com/aazWs.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/aazWs.png" alt="enter image description here"></a></p>
  
  <p>So far, this is not working properly. The best I can say is that the slice data appears to be putting each item to the same number, because the pie chart is divided equally among its parts. I'm getting nothing but a question mark for the labels.</p>
  
  <p>Any suggestions on how to fix this query OR another approach to satisfy my goal would be most appreciated.</p>