3 Replies Latest reply: Jul 9, 2014 2:53 AM by Aaron Couron RSS

    Changing dimensions with selections in a chart

      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).

       

      Any idea how to do it?