You should use cyclic group to navigate to any level of hierarchy. But if you want to use the Drill-Down functionality and see data for many selected values for the field you have to move this field on a top of the hierarchy. Your hierarchy looks good, but your data has one company only. It means for a Drill-down group no sense to show first level and it automatically drill down to the next level.
You can create a dummy company or use cyclic group.
Thanks Nick. I still don't understand why it it makes no sense to show the top level though.
If you think of it as a dashboard, the main guy in the company will want to see the overall sales / profit / returns etc etc for the whole company, possibly comparing across different years. Then he want to look at which states are over or under achieving in terms of a target and then which stores.
I was expecting to be able to see one bar for the whole company, click on that to see two bars for the states, click on one of the states and see however many stores are in that state.
If it is put in as a cyclic group you can select one of the states from a list and the graph will show the chart dropping to the correct level but it will still be showing at the company level rather than the state level unless I have clicked on the cyclic group button. I know what it is showing but I'm not sure that the users in the company will.
Although your company is the same and then a Drill down at company level would'nt make sense, but still I have attached an example QV file for you to have a look.
ABC.qvw 114.2 K
Ok, it has been a while .. but since this is not answered and I ran into the same thing today :
The solution is to add a fake second company, thus in your load script add:
LOAD * INLINE [
Note that Company 'X' will not show up in the chart.
TopDrillDown.qvw 133.8 K