2 Replies Latest reply on Dec 28, 2015 6:09 AM by MJMWeb

    Calculating & Graphing Like Columns

    MJMWeb

      Here is an example set of data:

       

      PersonGameScore
      JacobDarts100
      JacobDarts70
      TylerGolf36
      JacobGolf34
      TylerDarts120
      TylerGolf60

       

      I'd like to graph this data for each person with a pie chart, and I have that down so far with a subsummary part, but the area I'm stuck on is that that there should only be two sections to each pie chart: Darts, and Golf. Instead, there's three sections: Darts, Darts, and Golf, since Darts shows up two times in the data for each person.  So to be specific, I want the graph to not take each individual record but add together records under the same section if their Category Labels match.

       

      The simple solution would be to add these all together in Excel before I import the data over, but I'm hoping there is a way to handle this in Filemaker. Any suggestions?