Need assistance with edge summary for a percentage row. it is totalling instead

[cognovice]

Hi,
Could someone please assist me in getting the edge summary for a percentage row to be calculated differently to other rows that is totalling (adding).  Currently, my Gross Profit % row is adding at the total column (edge summary) instead of calculating the total percentage.  I am using dimensional package.

I have attached a screen shot of the report output.  Highlighted in yellow is the edge summary for "MTD Gross Profit %" which is totalling (adding) instead of calculating (total (MTD Gross Profit) / total ((MTD Sales)) 1706463/5285488 =  32.29%

Thank you

[HalfBloodPrince]

Change  aggregate function property to Calculated of query item Gross Profit %

[dougp]

It's hard to tell what's going on with just a screen capture.  Is the MTD Gross Profit % computed in the crosstab or in the query?

Can you reproduce the problem using the one of the sample databases?  If so, a report spec would be helpful.

[cognovice]

Change  aggregate function property to Calculated of query item Gross Profit %

Thank you very much HalfBloodPrince.  I changed the property to calculated and changed the solve order to 2 and it worked.