The correspondence between the salesman and the customer in Excel PivotTable report

First, let's look at the table below.

The table, a listed as the salesman name, B listed with the salesman has customer relationship customer name.

Below, we have to do is, how to show only a certain salesman and the salesman related to the customer name, only to see the corresponding relationship, do not look at other sales, other customer names.

This type of problem, using a PivotTable report to view the data, is quite handy and quite simple.

First select the AB Two column, and then, like the following figure, find the menu "data" → "PivotTable and PivotChart reports."

The following image dialog box pops up. Below, click the "Finish" button directly.

In this way, you can get the template of the following diagram, the crux of the problem is here, please read carefully.

① the customer name to the left and drop the row field here.

② then drag the salesman to the top, the column field dropped here.

③ the customer name to the largest in the middle, which is the "pivot field list" In the image above, please drag and drop.

When it's done, it's the effect of the following figure.

Now, let's look at how many customers a salesman has, and what is the name of each customer?

As shown above, click on the salesman, appear in the list, in which "Castle Peak", the others are not selected.

So simple, the result came out, now we can see the castle peak this salesman, a total of 5 customers, each customer's name, are shown on the left. This is the most classic one by one correspondence in a PivotTable application.