Hi, I am trying to utilize a pivot table to sum up retroactive payments due to employees. This is taking place for about 2 months back and so obviously you will see multiple line items per employee. I want to just be able to copy and send the pivot table data up to the team that handles the payments, but they need 3 required fields: Employee name, Employee Unique 7 digit ID number, and the amount owed to them. Currently, what I am finding is that the table is adding up all occurrences of the employee's ID number. I want it to just display what that person's unique ID is.
So in the end I am looking for it to display data among 3 columns as such:
Smith, John 1629617 $375.17
It is displaying as:
Smith, John 34221957 $375.17
It almost has it correct except for the fact that it is summing it up. I played around and I couldn't find a way to eliminate this without it ultimately NOT having it displayed how I want ti displayed above in bold. How might I do this?
So in the end I am looking for it to display data among 3 columns as such:
Smith, John 1629617 $375.17
It is displaying as:
Smith, John 34221957 $375.17
It almost has it correct except for the fact that it is summing it up. I played around and I couldn't find a way to eliminate this without it ultimately NOT having it displayed how I want ti displayed above in bold. How might I do this?
