I'm racking my brain trying to figure this out and coming up empty. Attached is a report similar to one my Company uses fairly often. It's a breakdown of sales by product type (Brand).

Is there any way to use the SubSum calcs generated by a report? If not I guess I could always create a report from an export of the SubSum report but it feels like there should be an easier way.

SubSumPercentage.zip

Not sure where exactly your difficulty is. You need to use the GetSummary() function to put sub-summary values into a calculation. Note that breakField must be in the same table.

I have not been able to get the results I want from the GetSummary function. It may be due to my lack of understanding the GetSummary function so thats why I posted the example file. The fields I am sorting by are in other tables.

Edited November 27, 200718 yr by Guest

OK. I guess I have to manipulate the data into a flat file format. Basically I had to create a report of the report. Seems like a lot of work to be able to perform a calculation on SubSum data but it works.

ReportOfReport.zip

OK. I guess I have to manipulate the data into a flat file format.

I don't see why.

SubSumPercentage.fp7.zip

Thanks for the example. At first I had trouble implementing it into my real file. Then it dawned on me I needed to set my Sort Records script step and the "Sub-summary when sorted by" options on the report layout to use the new cBrand and cCompanyID fields in the line items table.