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