Hi All, Please help me to solve the problem.
I have one sheet where we have created two filters
a) Country List
b) State list.
When first time report is rendered by defalut (All) is selected in both the filters.
1) When i changed the value of country filter to india and state filter value to punjab. Report data got filter out on the basis of both the filter
After that i changed the Country filter value of USA, Now ofcourse Punjab is not the state of the USA that is why data is not there in sheet.
We want state filter value to be reset to ALL whenever we change the value of the country filter.
On the State quick filter, right click and select Only Relevant Values. Now, when the user changes the Country, the State list will update with only the relevant states, and All of them will be selected.
Hope this helps!
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...