0 Replies Latest reply: Sep 6, 2016 9:23 AM by Christian Dahl RSS

    Combine Counts from tables in on Pivot Table

    Christian Dahl

      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