Could anybody help?

I'm looking to chart the total sales of my business month by month, I have a subsummary report that shows 12 monthly totals, but when I use GetSummary on the sum field (to paste to the chart) it only gets the first months total, how do you get Filemaker to read the next Subsummary part?

I think that will be easy to use for subsummary report total field. Look attachment

SubSummary.zip

Edited October 12, 200520 yr by Guest

Thanks for that.

The reporting side of things is covered, it's taking the sub-summary totals from the report and putting then in a chart which is the problem.

I am using GetSummary but this only takes the first subSummary value, I was looking for a method to 'grab' subsequent sub-totals.

Are you trying to do this with CDML?

If so, you would need to use Javascript. Some examples for summaries exist on this forum. If you can't find them, I can have a look through some of my old CDML files.

All the best.

Garry

SubSummary works normaly. Look attachment. Can you describe how you get values from table for chart? May be here is problem? I did charts for years and month on FM and it worked normaly.

SubSummary.zip

Edited October 14, 200520 yr by Guest

You need to go to "Preview" mode to see the sub-summary report.

Garry

I need a quick fix! Need to show summary fields using CDML. Can anyone help?

David

The only way I've found to do this is with Javascript. Here is an example:

Location | Total

[FMP-Record]

if (curr_loc == "[FMP-Field:locations::location_name]")

{

loc_total += [FMP-Field:qty];

tot_qty += [FMP-Field:qty]; }

else

{

if (curr_loc != "") { document.write(curr_loc + " | " + loc_total + "

"); };

curr_loc = "[FMP-Field:locations::location_name]";

loc_total = [FMP-Field:qty];

tot_qty += [FMP-Field:qty];

} ;

[/FMP-Record]

document.write(curr_loc + " | " + loc_total + "

");

document.write("Total Quantity: " + tot_qty);

This script summarizes quanities sold for each city.

Good Luck.

Garry