Percentages agregation in Discoverer 3.0

Does anyone know how to agregate a calculated percentage field in Discoverer? I want the agregation level be calculated as sum(x)/sum(y) and not sum(x/y), provided that the calculated field was defined as x/y at the detail level.

For example:

A folder with 3 data points: - Total Sales (from database) - Promotial Sales (from database) - % promotional sales (calculated field definrd as Promotional Sales/Total Sales)

If I have this values at the datail level:

  Total Sales Promotional Sales % Promotional Sales New York 200,00 50,00 25% Miami 150,00 75,00 50% Los Angeles 300,00 30,00 10%

If I have an hierarchy Country-City, when I agregate to the Country level I would like to receive the following results:

  Total Sales Promotional Sales % Promotional Sales USA 650,00 155,00  23.84%

But I'm getting 85% (25+50+10) at the % Promotional Sales column!

Can anyone help me?
Thank's

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet