Set Analysis - Keep Parent Dimension

[#1]

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.

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:

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

];

[arthur_dom]

See the attached QV.

I used triggers on County Field !Dropbox - qv1.qvw

[#3 · Accepted solution]

Hi Fabio,

I don't how much this will be more complex in your real example, but using the inline table you provided, you can try something like this:

sum({$<REGION = P(REGION), COUNTRY=>} VALUE)

[arthur_dom]

You can Add 2 triggers on Document Proprieties.

On COUNTRY the actions should be: Select in Field, choose field REGION and the value is =REGION, the second Action is Clean this field, choose COUNTRY. See attached files.

[#5]

That's it Jean-Pierre ...

Appreciate your help.