Tree Structure in webi prompts

Hi,

I have a question related to tree structure in webi, I have used 5 level cascading LOV in IDT and exported to repository.
The 5 level hierarchy is
Continent,
country,
state,
district,
city

Now I am getting the 5 level hierarchy in Prompts in Webi. Now my requirement is, if I have only one value under city, the hierarchy should stop at District, If district and City combinedly have only one value, the hierarchy should stop at State.
Any sugesstions on this requirement?

Thanks Inadvance,
Ram


rams2k (BOB member since 2014-07-14)