Percentage Change in SubSum report?

[sbg2]

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

[comment]

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.

[sbg2]

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, 2007 by Guest

[sbg2]

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

[comment]

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

I don't see why.

SubSumPercentage.fp7.zip

[sbg2]

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.