Analytics Software

Guys,

I have report where i am calculating % active and % inactive aircrafts for two different types. The data is as below


Columns : CustomerType Active Active % Inactive Inactive% Total

Data : COMMERCIAL 277 38.96 434 61.04 711
CORPORATE 4593 48.42 4892 51.58 9485
SUM : 4870 87.38 5326 112.62 10196

The Active% and Inactive% are calculations as below

Active % = ( Active/Total )*100 (i.e (277/711) * 100 = 38.96 and (4593/9485)*100 = 48.42 )
Inactive % = ( Inactive/Total )*100 (i.e (434/711)*100 = 61.04 and (4892/9485)*100 = 51.58 )

The sum is caculated by the Totals functinality in discoverer , the sum for Active 5 and Inactive % is being calculated incorrectly.

Is it possible to make discoverer to calculate the sum for Active % as ( 4870/10196 ) * 100 and for Inactive % as ( 5326/10196) * 100 ??

Please help.

thanks