I need to add a calculation to my pivot table that takes the subtotal of the dept hrs/employee total hrs and * 86.67 hrs. I am not sure how to do calculations in a pivot table based on subtotals and totals.
For example:
10-Employee Hrs Calc
Dept 1
2/21 4 (Tlt Dept1/Ttl 10-Employee)*86.67
2/22 8 (Tlt Dept1/Ttl 10-Employee)*86.67
Ttl Dept 1 12 (Tlt Dept1/Ttl 10-Employee)*86.67
Dept 2
2/21 4 (Tlt Dept2/Ttl 10-Employee)*86.67
2/23 8 (Tlt Dept1/Ttl 10-Employee)*86.67
Ttl Dept 2 12 (Tlt Dept1/Ttl 10-Employee)*86.67
Ttl 10-Employee 24
I have attached a sample Excel file.
Bookmarks