Dear All,
Really hope you can give me the right pointers for solving my problem and also hope it's easy to understand here goes:
(The structure of the database is a bit bigger than this, so here is a snapshot of what I want to solve)
I have the table "Service" with:
-ServiceName
-SalesPersonID
-CoordPersonID
This table is connected with Left Join:
Table ContactSales:
-SalesPersonID
-SalesPersonName
and left join:
Table ContactCoord:
-CoordPersonID
-CoordPersonName
I then want to make a pivot table with the count of how many services each person has performed (Samme person can be on both places at the service table, but should only be counted ones).
If I use ContactSales as rows I can't see the Coord part it's simply not displayed any suggestions?
Really hope it makes sense.
BR
Christian
