9 Replies Latest reply on Jun 12, 2019 3:45 AM by vissu p

    Filtering data based on parameter

    vissu p

      Hello All,


      I have a parameter select country having values India,US.

      I created a calculated filed for filter to get cities based on country selected. So If I select India I need to show Hyd,Mumbai. If I select US I need show Washington,California .

      I am using below code but not getting the exact result. Please suggest

      if [Country] ="US" THEN "California " 
      elseif [Country] ="US" THEN "Washington"
      elseif [Country] ="India" THEN "Hyd"
      elseif [Country] ="India" THEN "Mumbai"
      else ""