What kind of "graphical representation"? a chart?
There are ways to compute totals and subtotals using summary fields. There are ways to get the same values using a relationship and the sum function. ExecuteSQL can use aggregate functions to also compute these totals. But the devil is in the details--including how you want to present those totals on the screen/page and whether you can set up a grand total or need to produce a sub total.
Thank you for the swift reply.
As an example: Add another Calculated field in the table above that has an aggregated record calculation if the attribute is strength. This would for Steve Pigeon give him a Total Strength value of 2100 and a Total Power value of 300. I would like to create a Pie Chart that has one slice at 2100 and one slice of 300.
In effect:using pseudo code terms:
Do While(Player Name = "Steve Pigeon")
Add Calc1 Value to Total Calc1
Add Calc2 Value to Total Calc2
Then use Total Calc1 and Total Calc2 to construct the Pie Chart.
As I intimated earlier, there may be a very simple thing I am missing here but I cannot spot it in the manual!
But what I am describing does not use a script. It's a combination of other design elements in FileMaker that produce the needed values.
Am I correct that your Pie Chart charts data for a single player?
And each "wedge" of that pie chart represents a total for a different Attribute?
And you have two fields in each record? value1, value2?
And you need to chart sub totals of the sum of these two fields for each attribute?
If that is correct, you need a calculation field defined as
Value1 + Value 2
There is no need for this calculation to only add values if this is a specific attribute. We'll be using a different means to get totals for each for our pie chart wedges.
Define a summary field that computes the total of this calculation field.
Perform a find for just one player such as "Steve Pigeon" so that your found set is limited to the stats for that player.
Sort them by attribute.
In chart setup, specify the attribute field as the label for your wedges and this summary field as the field to use for the "width" of your wedges.
In the data source settings for your chart, make sure that it specifies: Current Found Set and Summarized Groups of records.
It looks to me that I need to shift away from my normal way of looking at things which is by using a language to get my results. Will take a long look at your answer tomorrow - been on the go for ten hours now. I'm sure that you have given me the way forward that I needed. If not - I should be shot :)
Thank you so much for your guidance. Having followed your advice this has opened up a complete cornucopia of delights!