Calculating sub total in Crystal Reports for Enterprise

Hi all,

I have to display a report with BW hierarchy (Divisions--->Districts--->Jobs)

Comp Code Profit Center 60-90 days 90-120 days Dist A (header2) Job 1 (header 3) 1000 2100 40000 50000 Job2 (header 3) 3000 3223 40000 50000 sum (footer 3) 80000 100000 Dvision A TOTAL (footer 1) 80000 100000

I want to display the report in the above format.

But the problem when I'm doing the sub total for jobs, sum is carried out for each row of job instead of sum of all jobs thereby creating additional row.

How to solve this problem?

Please advise.

Thanks

John