02-18-2016 10:43 AM
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.
02-18-2016 05:57 PM
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.