Here is an example set of data:
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?