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
