4 Replies Latest reply: May 24, 2014 7:21 PM by Arthur Molino RSS

    Set Analysis - Keep Parent Dimension

    Fabio Alamini

      Dear all, good morning.

       

      I'm having some issues about creating a set analysis to keep the parent dimension when selected one specific field.

      For example, when select BRAZIL in country the list, the table should keep all other countries for the same region.

      SA_DOUBT.png

      I mean, when I select a country I want that the table understand that I select the whole Region, and not a specific country.Like image below:

      SA_DOUBT2.png

      Someone has a clue about it?

      Thanks !!

       

      LOAD * INLINE [

          REGION, COUNTRY, VALUE

          AMERICA, BRAZIL, 10

          AMERICA, US, 20

          EUROPE, ITALY, 30

          EUROPE, ENGLAND, 15

          ASIA, JAPAN, 12

          ASIA, CHINA, 18

      ];