Summary and Detail Join

[Kalachuchi]

Hello, I have two table one is summary and one is detail.

Basically Visual (Barchart) is for summary and table is for detail

Summary

Region	Country	New Request	Old Request	Target Request
APAC	Australia	1	2	3
ASEAN	Singapore	1		1

Detail

Status	Region	Country	ClientName
New Request	APAC	Australia	Honda
Old Request	APAC	Australia	Jeep
New Request	ASEAN	Singapore	Ford
Target Request	ASEAN	Singapore	Nissan

[v-jingzhang]

@KalachuchiCan you show the expected output with sample data after joining two tables?

[Fowmy]

@Kalachuchi 

Your detail table has an additional attribute CLIENT NAME so you can create a column in both tables as

NewCol = [Region]& "-" & [Country] & "-" & [Client Name]

________________________

If my answer was helpful, please click Accept it as the solution to help other members find it useful

Click on the Thumbs-Up icon if you like this reply 🙂

Website YouTube  LinkedIn

[Kalachuchi]

@Fowmy  I have another table for region/country which filters both detail and summary table. How can I do it?

[amitchandak]

@Kalachuchi , Looking ate this you can create a new column in both tables

key = [Region] & "-" [Country]

And join these two