if [Country] ="US" and (City = "California" OR City = "Washington") THEN TRUE
elseif [Country] ="India" and (City="Hyd" OR City = "Mumbai") THEN TRUE
change the calculation like above , place the same in filter select TRUE .
Hope this helps
Plz mark this answer as correct & helpful to close the thread
Can you clarify from where are the cities information is coming from?
Drag Country and City fields to filter shelf and select city filter and choose Only Relevant Values option, what you are trying to do is to load cities based on country selected.
I am not getting cities data from this code.Getting true,false,null values.
select true , drag cities column to sheet you will see the respective cities based on the selection
If its not helping could you please attach a workbook in twbx format plz
Its coming from database.I dont have a country filed.I have a country parameter and values are hardcoded.
I need to get cities based on country selected
I shouldn't drag the filed to sheet.The cities values should be a filter.
So if I select us canada then another filter should show California and Washington.
and India then mumbai and Hyd
If your Country and State is coming from fields then you have to drag your Country and State in the filters pane. Put the State Filter to Show only relevant values.
I am attaching the screenshot below and .twbx file for reference.
I hope it helps If it fulfills your requirement then mark it as the helpful and correct answer.
Relevant values.twbx 8.0 MB
After selecting True , Drag Cities to filter --> Select Use all Values --> Ok
Right Click on the City filter --> Show filter --> After showing click on the filter to show relevant values
have data like below
only relevant values
Hope this helps
plz mark this answer as correct & helpful to close the thread
Thank you Naveen for your time.