4 Replies Latest reply: Oct 8, 2018 8:14 AM by Leszek Piekielniak RSS

    Sum based on values from 2 tables

    Leszek Piekielniak

      Hello colleagues,

       

      I need to create a Pivot Table that will show salaries per pay period. I have two tables, first:

       

      payroll_number, region, department, split, date

       

      and 2nd as:

       

      date, payroll_number, salary

       

      the table should look like

       

                            Date1,                     Date 2,                    Date3

      Department  split*Sum(value)      split*Sum(value)     split*Sum(value)

       

      I joined the tables on payroll_number but the sum(value) does not show the correct value. It seems like I need to match the dates in both tables somehow?  

       

      Any help would be highly appreciated!

       

      Thanks,

       

      Leszek