Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Can you confirm the order of levels please?
Andy