Return to FileMaker.com
How is the best way to create a pie chart based on a calc field from 8 different portals to make up the total pie?
I originally started with the if ( field a = field b ; sum (budget field)) This will only return the first # not the sum of the 4 where all conditions are met.
You can't chart Y values for groups of sorted records when the data is from a related table.
You'll need to generate delimited data using ExecuteSQL and aggregate functions to get one value for each "wedge" of your pie chart.
Retrieving data ...