Page 1 of 1

Group Columns - Outline

Posted: Sun May 09, 2010 8:02 am
by 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

Re: Group Columns - Outline

Posted: Wed May 12, 2010 5:52 am
by henry2495
Good day

I have found my problem.
Thank you