4 Replies Latest reply on Aug 10, 2016 4:28 AM by Roger Hawaibam

    Multiple Dimensions filter

    Roger Hawaibam

      Hi All,

       

      I'm new in this group. I'm not sure whether I'm putting this problem at right forum.Kindly help

       

      Below given is the data

       

      DATA

      RegionCountryGDP
      AmericaUSA120
      AmericaCanada90
      EuropeEngland105
      EuropeSweden89
      AsiaIndia84
      AsiaJapan119
      AfricaSouth Africa94
      AfricaZimbabwe89
      AsiaKorea94

       

      Using filters ( List: All, America, Europe, Africa & Asia) , the result what I'm looking for is when I select "All" then the below table (Table 1) show.

      and When Select any Region then instead of Region respective Countries should show (Table 2). when I select America.

       

      Table 1.

      Region/CountryGDP
      America210
      Asia213
      Africa183
      Europe194

       

       

      Table 2 ( when America Region is Selected)

      Region/CountryGDP
      USA120
      Canada90

       

      Thank you

       

      Regards,