Hello!
I'm sure this is really simple but I must be simpler. What I want is to show the associated region when the user selects a site from a drop-down.
In a sheet title I have
Region: <Region> | Site: <Site Name>
When I select a state from the State filter the name of the state shows up in the title but region does not change. How can I get region to change based on state selection?
I tried attaching a workbook that used the Superstore data but it said the workbook was too large. Does anyone know how to pare down the dataset?
Thanks,
Brian
Region does not Have any Geographic Role, Make a copy of Region, Give It a Geographic Role by Right Click as Country/Regions and you Get This in Title
and
Please See attached
Thanks
Deepak
If It Helps, Pl mark It Helpful and CORRECT to Close Thread
