Joining Issue between two tables

[SatyaPaleti]

Hi Everyone,

There is a struck in the work due to following issue. Can some one please help to resolve this issue

I am having two tables.

Table 1 consists of following fields

Region,

Country,

Cust ID

Table 2 Consists of following fields

Region,

Country,

State

Here the re requirement is. I need to show Count of (Region&'-'&Country&'-'&Customer ID) by using State as dimension.

In the 2nd Table we don't have Customer ID but we want to show the Data by State wise.

I have done the joining between two tables and I have created a Chart but count of Customer is repeating for every State.

I have also tried Applymap to fetch state information from Table 2 to Table 1 but it's fetching only single value out of multiple state values.

Can some one please help to resolve this issue 

[anat]

if possible can you share sample data and expected output?