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
Create group on Dept . then select rev and select automatic summary from the summarize option .