D
DtTall
I have one worksheet with employee numbers as the rows and product
catagories in the columns. That data stored here is the percent of
time that the employee number spends in each product catagory:
Emp. # Cat. 1 Cat. 2 Cat. 3 Cat. 4
12345 .5 .3 .2 0
The next sheet contains Emp. # and salary:
Emp. # Salary
12345 10000
My question is there anyway to get a pivot table to combine these
items so that the end result would be
Emp. # Cat. 1 Cat. 2 Cat. 3 Cat. 4
12345 5000 3000 2000 0
If that is possible, what if I also have Areas and Departments in the
second worksheet
Emp #. Area Dept Salary
12345 Design 100 10000
And would like the pivot table to be abe to be sorted such that:
Cat. 1 Cat. 2 Cat. 3
Cat. 4
Area Dept. Emp. #
Design 100 12345 5000 3000 2000 0
12346 5000 3000 2000
0
If there is any way to do what I am asking I would really like to
know. Thanks in advance for your help.
catagories in the columns. That data stored here is the percent of
time that the employee number spends in each product catagory:
Emp. # Cat. 1 Cat. 2 Cat. 3 Cat. 4
12345 .5 .3 .2 0
The next sheet contains Emp. # and salary:
Emp. # Salary
12345 10000
My question is there anyway to get a pivot table to combine these
items so that the end result would be
Emp. # Cat. 1 Cat. 2 Cat. 3 Cat. 4
12345 5000 3000 2000 0
If that is possible, what if I also have Areas and Departments in the
second worksheet
Emp #. Area Dept Salary
12345 Design 100 10000
And would like the pivot table to be abe to be sorted such that:
Cat. 1 Cat. 2 Cat. 3
Cat. 4
Area Dept. Emp. #
Design 100 12345 5000 3000 2000 0
12346 5000 3000 2000
0
If there is any way to do what I am asking I would really like to
know. Thanks in advance for your help.