Data item calculation

[Kid_in_Cognos]

i have a data items like dept, revenue

Dept       Rev
D01   1000
D02   500
D02   500
D01   700


I need to list and calculate based on the Did's.like below.
D01   1000
D01   700

Total D01 - 1700

D02   500
D02   500

Total D02 - 1000


Total Dept Rev - 2700



I used page set and able to acheive for separate dept id totals. But could not able to do for the Total Dept Rev.Any idea how can I acheive this?


Thanks

[HalfBloodPrince]

Create group on Dept . then select rev and select automatic summary from the summarize option .