Hello Experts
I have setup drill level as
LEVEL1 - Country
LEVEL2 - State
LEVEL3 - City
User wants the prompt at state level and also as their business is highly concentrated on US, they need US states in level 2 prompt.
Using SQL i acheived the same. So my prompts looks like follows
Select states -> All US states, Texas, california, florida, Hawai etc
The issue comes with drill
When user selects ALL us states, the user wants the drill to start with level 1 (ie country), where as when user selects any states then drill level should start with level 2 (ie state)
Let us know is it possible in Webi 4.1 sp5 ?
Thanks
Ben