On which table is your chart layout based?
Do your sum calculation fields return the correct sub totals?
Thanks for responding, I've checked out the SUM totals of the calculation fields and weirdly enough they don't add up to what I'd expect them to be, they just show the SUM total of all records on that field. The layout relationship that the chart is based on is based on a date field, I have a date field set to the beginning of each week in the financials table.
they just show the SUM total of all records on that field.
That description doesn't really make sense. Can you explain what you mean by that?
Sum is designed to sum a "list" of values.
That list can be explicitly listed as fields from the same record: Sum ( field1 ; field2 ; field3 ) If you just use: Sum ( Field1 ) , sum returns the value of Field1.
That list can be the repetitions of a repeating field: Sum ( RepeatingField )
That list can be from a set of related records: Sum ( RelatedTable::Field )
Only the last example sums data from more than one record. Which example matches what you have tried to use?
Please note that the sum function is not the only way to get such an aggregate value. A Summary field may also be used to get a total or sub total from a group of records.
Sorry the SUM fields are displaying the correct totals mistake on my part, blurry eyes.
Let me work backward through it. I have 3 SUM fields that display totals of 3 calculation fields. The calculation fields result in a number. The Number is set in based upon a logical function from 2 fields in the same table. This is the calculation used "If ( Payment Type = "Cash" ; Payment ; 0)". "payment type" and "payment" are fields on the same table, payment being a number field "payment type" being a drop down value list of "cash, cheque and Bank Transfer"
This all works fine, I just need to know how to use the 3 SUM fields in the chart setup box, to create a pie chart.
Yet there is more than one way you could have set this up and critical details are not clear. To repeat:
On what table is your chart layout based? That "Context" will determine options for how you set this up. (What is selected in "show records from" in Layout Setup?)
And are your "SUM" fields calculation fields or fields of type summary.
Please note that your pie chart is possible by using a single summary field and sorting your records to group them, but that may not fit the "context" in which you are trying to set up your chart.
The Layout setup shows records from reports. Reports is a table with global data. The records that the piechart is based on is called Transactions. Reports and Transactions are related.
It might be simpler to base your layout on Transactions, A single summary field can then return the subtotals for each wedge.
But working with Reports as your layout context:
List ( SumField1 ; SumField2 ; SumField3 )
can be the calculation you use for your y-series (wedges).
List ( "Field1Wedgelabel" ; "Field2WedgeLabel" ; "Field3WedgeLabel" )
Can be the x-series (wedge labels).
In your data source settings, you'll need to specify that you are using delimited data.
That's exactly what I needed, never heard of the List function, brilliant learn something new every day.
never heard of the List function
The List function is one of the most useful functions available in FileMaker. In Version 12, it's somewhat eclipsed by ExecuteSQL as it can produce the same list, but also with many more tools for controlling what items appear in that list.