Select part of list from syn key

[#1]

Dear community,

I have 2 tables (Spends and Sales) which consists one same field - Country, so Country is syn key.

However, some countries are not available in Spends table.

When i select one country which is not available in Spends, the spend vs sales chart will show nothing.

Can I show the country list box where it shows only country in Spends table?

Kindly help, urgent...

Thanks and best regards,

Chanel

[tresesco]

May be like attached sample?

[#3]

Dear tresesco,

It seems working fine but in my document, it is not working, i guess is because of i set the country region hierarchy as shown below:

Region:

Hierarchy (NodeID,RegionHierarchy,Country,'',Country,'RegionCountry','~')

LOAD Country as NodeID,

     Country,

     Country as Countrytarget,

     Region as RegionHierarchy,

     Region

FROM

[..\1_Resources\Lookup\Region_Country.xlsx]

(ooxml, embedded labels, table is Sheet1);

Do you see anything wrong on the script and the table? is it linkage problem?

Thanks and best regards,

Chanel

[tresesco]

Hi Chanel,

I guess so. But it would be very tough to rightly point out without having a look at the sample app. Scramble and reduce the data and share it with expected out put explained if possible.