1 Reply Latest reply on Jan 18, 2019 6:28 AM by Rita Khalil

    Region and Country Cascading Filter for Multiple Region and country seprated by Semi Colon

    Sazid khan

      Please help how can i filter data from Region and Country Column like i need to give user selection for selecting Region then ASSOCIATED Country need to shows in next Country Filter. Please see below data set

       

      two filter need to created one is

      Region

      NORTH AMERICA

      ASIA PACIFIC

      LATIN AMERICA

      EUROPE

      MIDDLE EAST

      AFRICA

       

      Country ( need to cascade based on the region) User Selection

      UNITED STATES

      JAPAN

      SINGAPORE

      HONK KONG

      KOREA REPUBLIC

      AUSTRALIA

      TAIWAN

      INDIA

      UNITED KINGDOM

      ITLAY

      GERMANY

      SPAIN

       

      Like that.......

        

      Issue IdRegionCountry
      1NORTH AMERICAUNITED STATES
      2NORTH AMERICAUNITED STATES
      3NORTH AMERICAUNITED STATES
      4NORTH AMERICAUNITED STATES
      5NORTH AMERICAUNITED STATES
      6NORTH AMERICAUNITED STATES
      7ASIA PACIFICJAPAN;SINGAPORE;HONG KONG;KOREA REPUBLIC OF;AUSTRALIA
      8ASIA PACIFICAUSTRALIA;JAPAN;TAIWAN;SINGAPORE;HONG KONG;KOREA REPUBLIC OF
      9ASIA PACIFICJAPAN;SINGAPORE;HONG KONG;KOREA REPUBLIC OF;AUSTRALIA
      10ASIA PACIFICAUSTRALIA;JAPAN;TAIWAN;SINGAPORE;HONG KONG;KOREA REPUBLIC OF
      11ASIA PACIFICJAPAN;SINGAPORE;HONG KONG;KOREA REPUBLIC OF;AUSTRALIA
      12ASIA PACIFICAUSTRALIA;JAPAN;TAIWAN;SINGAPORE;HONG KONG;KOREA REPUBLIC OF
      13ASIA PACIFICTAIWAN
      14ASIA PACIFICTAIWAN
      15ASIA PACIFICTAIWAN
      16LATIN AMERICABRAZIL
      17LATIN AMERICABRAZIL
      18LATIN AMERICABRAZIL
      19LATIN AMERICABRAZIL
      20EUROPE&MIDDLE EAST&AFRICAUNITED KINGDOM
      21EUROPE&MIDDLE EAST&AFRICAUNITED KINGDOM
      22ASIA PACIFICINDIA
      23ASIA PACIFICINDIA
      24NORTH AMERICAUNITED STATES
      25NORTH AMERICAUNITED STATES
      26NORTH AMERICAUNITED STATES
      27NORTH AMERICAUNITED STATES
      28NORTH AMERICAUNITED STATES
      29ASIA PACIFICTAIWAN
      30EUROPE&MIDDLE EAST&AFRICAAUSTRIA;GERMANY;NETHERLANDS;SPAIN;ITALY;LUXEMBOURG;SWITZERLAND;SWEDEN;FRANCE
      31NORTH AMERICAUNITED STATES
      32ASIA PACIFICTAIWAN
      33EUROPE&MIDDLE EAST&AFRICAAUSTRIA;GERMANY;NETHERLANDS;SPAIN;ITALY;LUXEMBOURG;SWITZERLAND;SWEDEN;FRANCE
      34NORTH AMERICAUNITED STATES
      35ASIA PACIFICTAIWAN
      36NORTH AMERICAUNITED STATES
      37NORTH AMERICAUNITED STATES
      38LATIN AMERICABRAZIL
      39LATIN AMERICABRAZIL
      40ASIA PACIFIC;NORTH AMERICA;EUROPE&MIDDLE EAST&AFRICASINGAPORE;UNITED KINGDOM;UNITED STATES
      41ASIA PACIFIC;NORTH AMERICA;EUROPE&MIDDLE EAST&AFRICAPHILIPPINES;UNITED STATES;IRELAND
      42ASIA PACIFIC;NORTH AMERICA;EUROPE&MIDDLE EAST&AFRICAPHILIPPINES;UNITED STATES;IRELAND