2 Replies Latest reply on Mar 1, 2016 9:21 AM by Matt Chadsey

    Help Connecting or Blending Simple Tables

    Matt Chadsey

      Good Evening - I had what I thought was a simple problem but it appears not to be for me.  I have two sets of data - projected hours and actual hours.  Each is has a date, company, and staff name.  I am trying to produce a report that shows Company - Staff - Projected Hours and Actual hours.  The problem is that one staff member or company may occur as projected and not actual and visa versa. 

       

      The final table should look something like this

       

      CompanyStaffProjectedActual
      Company A Matt2010
      Ken015
      Company BJosh200

       

      No matter how I blend/join the tables I get incorrect results - sums of all values regardless of company or staff member.  I think this must be straight forward but I cannot see how to organize and link the tabs.

       

      Thanks in advance.  Matt