Hi
My data has the following data format:
Name Department Payment
Bob Cutting $10
Bob Splicing $ 5
Jill Cutting $ 7
Jill Finishing $ 4
Peter Painting $ 2
I want to construct a pivot table that will allow me to see the total compensation paid to each employee IF they worked in a particular department.
For example, if I select Cutting, I want to see something like this:
Bob Cutting $10
Bob Splicing $ 5
Bob $15
Jill Cutting $ 7
Jill Finishing $4
Jill $11
Note that Peter is excluded since he did not work in Cutting at all.
I can't figure out how to selectively filter so that I only see the employees who worked in the Cutting department, but the subtotals include work they did in other departments.
Thanks!
e
Bookmarks