Creating dependant filters

[CMS_CWT]

I want to create a set of dependant filters to dynamically update a
set of charts. Specifically, my data source has multiple rows each
with World Area, Country, City. I want to be able to select a World
Area, then select from just the Countries in that World Area, then
from just the Cities in that country to filter the charts. As a
second option, I would like to be able to just select a City without
first selecting World Area/ Country. I'm looking for assistance on
how best to accomplish this.

 

[GS]

CMS_CWT has brought this to us :

I want to create a set of dependant filters to dynamically update a
set of charts. Specifically, my data source has multiple rows each
with World Area, Country, City. I want to be able to select a World
Area, then select from just the Countries in that World Area, then
from just the Cities in that country to filter the charts. As a
second option, I would like to be able to just select a City without
first selecting World Area/ Country. I'm looking for assistance on
how best to accomplish this.

Not sure but maybe...

http://www.contextures.com/xlDataVal15.html