Set analysis issue

[peterstalberg]

Hi experts,

I'm stuck in a set analysis expression not giving me the expected result. Check out the table below, country Sweden and customer 'BB' & 'CC' are selected. Measures in column 3-5 gives me the expected result. For column 6 I want to show all sum(Sales) except for customers NOT selected under the selected country ('AA' & 'DD'). Any help on how to phrase this set expression would be highly appreciated. RGDS//Peter

[tresesco]

Your first three measures look to be equivalent to simple  -   Sum(Sales). While for the last one, you could try like:

Sum({1<Customer=e(Customer)>}Sales)

[peterstalberg]

Hi Tresesco,

Thank you very much for your response. Unfortunately, this expression excludes customer 'BB' & 'CC'. AS described previously, I want to exclude 'AA' & 'DD' which has not be selected under Sweden an then include everything else. I have attached the qvf for clarity. Appreciate any further input. Regards//Peter

Note: Sweden, 'BB' & 'CC' are selected in the table.

[tresesco · Accepted solution]

Well, if you are looking for something like below:

Sum({1<Customer=e({<Customer,Country=$::Country>}Customer)>+<Customer=p(Customer)>}Sales)

Possibly the expression can be simplified, you can give a try.

[peterstalberg]

Hi Tresesco,

Spot on - thank you very much😀 Not sure if I can simplify your suggestion but I'll try to change the other measures using  e & p switches rather than the "getfieldselections" approach. RGDS//Peter