I am trying to total a report by department but it is not working.

I have a report that is grouped by company, contract, department.

Inside the detail of the report is each contract item, department and amount

i.e.

10 - company
123456 - contract
02 - department
1 line item 02 department 500.00
2 line item 02 department 100.00

03 - department
3 line item 03 department 200.00
4 line item 03 department 50.00

04 - department
5 line item 04 department 25.00
6 line item 04 department 10.00

What I am trying to do is at the contract level - is total each department.

i.e.

10 - company
12345 - contract 02 600.00 03 250.00 04 35.00

I hope this makes sense - very new to the forum please excuse any formatting issues.

Thank you in advance

Okay - I am not familiar with Cross-Tabs. I will give it a try.

it is the easiest way and most fluid, especially if you have dynamic data in the departments

Thank you for the response. Is there a way to add another column for contract description?

12345 - ABC Contract 500.00 100.00 50.00 40.00 690.00

Thanks in advance

if you have the name in your data set you can just group on that instead. Or you have concatenate them like

totext(table.contractnumber,0,'')+':'+ table.contractname