Hierarchy in the filters used in section prompt.

[abhilashatiwari]

Hi,

I have two filters named "Country" and "City" used as section prompt in my report. I want to create a interaction/ hierarchy, in a way that if I select a country in "Country"filter, then the cities should be filltered according to the selection made for the country.

I can do this in the report, but unable to do in for section prompt

Please let me know if its possible using parameter or any workaround.

Thanks!

Regards,
Abhi

[Explore_SAS]

Hi Abhilash,

I think use we can filter the 1 value using the another.

I selected a below use case,

1. added 2 dropdowns with country country and city in sectional filter. and created a character parameter on country category. and assigned that character parameter to Country dropdown.

Then I selected the city dropdown and clicked on Filters tab to add create a filter on it.

and I added below condition country = 'character parameter' 

This gives the desired result of filter based on what you select in the country dropdown.

I hope this resolves your question.

Thanks,