Matching two columns

[SachinNataraj305]

Hi,

I want to create two tables with the following data set

customer	job number	sale	volume
A	AA-00		5
AA	AA-01	100
AB	AA-02	200
B	BB-00		4
BA	BB-01	50
BB	BB-02	300

the column customer has both main and sub customer names

Table 1) - with all sub customer names, job, sale

table 2) with main customer name, job & volume

I want to visualize the customer names if i select customer AA in table 1. I want the table 2 to show the information of main customer.

Can you please help me with this,

Thank you

Sachin