Drill Down

[#1]

I have data for Region, Division, Territory. I want to create a drill down/ cyclic group. I have another list box with this group and I want to control the selection in such a way.

Territory	Division	Region	Sales	User
t1	d1	r1	100	u1
t2	d1	r1	200	u2
t3	d2	r1	300	u3
t4	d2	r1	400	u4

I want to show sale as measure.

Suppose territory is first level selected (currently t1 selected)

When I drill to next level i.e. division, It should be selected as d1 and value of sales should be coming 500.

Similarly when drill to region sales should be 1000 and value r1 should be selected.

What should be approach to implement it. Its really very critical. Please guide the correct way to do it

[awhitfield]

Can you confirm the order of levels please?

Andy