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!