Group Columns - Outline

[henry2495]

Good Day

I am trying to accomplish the following group, but it does not work.

My data is as follows

Dept Area Sales
1 A 100
1 A 100
1 B 100
1 B 100
2 A 200
2 A 200
2 B 200

I want to group it as follows.

+1 300
(if i expand the + now then I should see the following)
+A 200
+B 200
( IF I expand The A or B then I want to see the detail for A and B )
A 100
A 100

+2 600

I manage with my code to get the group right for the area, but not the group for Dept.

Please assist.

Regards

[henry2495]

Good day

I have found my problem.
Thank you