Set analysis

[peterstalberg]

Hi experts,

In this example I select one country only [Country]='Sweden'  and some customers belonging to this country [Customer]='BB', 'CC' . I get the expected measures in column 3-5 but for column 6 I can't figure out how to write the correct set expression. For this measures I want to include all Countries & Customer except Customers not selected under the selected country ('AA', 'DD') if there was a selection of customers. 

Help on this would be highly appreciated. RGDS//Peter

Country	Customer	{1} sum(Sales)	{1 <Country={'$(=getfieldselections(Country))'}> } sum(Sales)	{1 <Country={'$(=getfieldselections(Country))'},  Customer=$::Customer > }  sum(Sales)	?
SA:	-	1700	700	500	1500
Sweden	AA	150	150	-	-
Sweden	BB	200	200	200	200
Sweden	CC	300	300	300	300
Sweden	DD	50	50	-	-
Norway	EE	300	-	-	300
Norway	FF	200	-	-	200
Norway	GG	200	-	-	200
Norway	HH	300	-	-	300