Alternate State Set Analysis

[sangeeth8787]

Hi,

I have created two multi box with Group1 and Group2.

I am able to write set analysis difference between Group 1 and Group2.

How to achieve in set analysis

sum({<Group2[CountryCode] = Group1{Intracountry code}>}Value)

User had selected IntraCountryCode in Group1 Filters, but he don't want manually select CountryCode filter from Group2

I had tried following, but no luck

sum({<CountryCode = {"=(GetfieldSelection(IntracountryCode,'','Group1' "}>}Values) 

Is it feasible?

Many Thanks

[sunny_talwar · Accepted solution]

How about this?

Sum({Group2<[CountryCode] = P({Group1} [Intracountry code])>}Value)

[sangeeth8787]

Hi,

Sum({[2nd Company]<yrperiod = {">$(20030001)<=$(=Lastperiod)"},InterCompany = p({[1st Company]}CmpCode)>}InterCompany_DocValue)

The above expression amended based your hint expression provided earlier, but it returning wrong values. 

[sangeeth8787]

Sorry for earlier reply, It worked perfect! Many Thanks