Subtotals

[LeonelSanchezJr]

I have a report which is grouped by COLUMN A and has SUBTOTALS and GRAND TOTALS.

Column D = (COLUMN C / COLUMN B) * 100
So, the SUBTOTAL for COLUMN C should be calculated similarly; not SUMMED.

COLUMN A COLUMN B COLUMN C COLUMN D
ABC 90 25 27.77%
ABC 80 33 41.25%

Subtotal: 170 58 34.12%

The same goes for the GRAND TOTALS.

Thanks,

Leo ;-)

 

[jimster06]

Take a look at the RECOMPUTE or SUMMARIZE commands.