Pivot table help!!
I'm new to pivot tables and would greatly appreciate any help. What I'm
trying to accomplish is creating a pivot table for tracking employee vacation
time. I have all of the data and created a simple Pivot table that shows how
many vacation took, by payroll period. My problem is creating a new pivot to
calculate the total hours remaining of vacation.
Sample:
Payroll Period: Vacation allotted hours Vacation hours taken Vac hours left
1/12/2007 100 15
85
Any help will be greatly appreciated.
Thanks
|