Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
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)
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.
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.
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