I have a regional hierarchy (Country, State and City - as three columns)... i want a chart in which the dimension changes automatically depending on what is selected and it shows a level lower than that. So if Country, state and city are Level 1, 2 and 3 respectively and someone selects a country in level 1 - the chart should have Level 2 (states within the city) as the dimension. If a state is selected, it should change dimension to a level 3 (cities within the selected state(s)). With no selections, i want level 1 (country).
