H
heyredone
I have read several instructions on-line & here on combining pivot table data
and am confused and/or I'm doing it wrong. Anyone's help would be sincerely
appreciated! Using Excel 2003.
I have pivot tables of employee time punch data and more than/less than
number of hours worked per day calculations. 1 pivot table worksheet = 1
month; 1 workbook = 12 months (Jan-Dec); there are 5 workbooks (2004-2008). I
want to combine pivot table data for months Jan-Dec into 1 pivot table. Can I
do that? If so, how?
Data labels are "Last Name", "First Name", "Badge", "More than 3.5 hrs?",
"More than 5 hrs?", "More than 10 hrs?", "Less than 12 hrs?" etc. with the
"More than" & "Less than" as 'True'/'False' or 'n/a' results. Goal is to see
over the course of 1 year, the count of 'True' and 'False' and 'n/a' results
for each employee. I will then need to combine over the course of 2004-2008,
the same count results for each employee. I'll start with info. per year for
now, though.
I hope this makes sense. Need more information, please ask. Thank you very
much!
and am confused and/or I'm doing it wrong. Anyone's help would be sincerely
appreciated! Using Excel 2003.
I have pivot tables of employee time punch data and more than/less than
number of hours worked per day calculations. 1 pivot table worksheet = 1
month; 1 workbook = 12 months (Jan-Dec); there are 5 workbooks (2004-2008). I
want to combine pivot table data for months Jan-Dec into 1 pivot table. Can I
do that? If so, how?
Data labels are "Last Name", "First Name", "Badge", "More than 3.5 hrs?",
"More than 5 hrs?", "More than 10 hrs?", "Less than 12 hrs?" etc. with the
"More than" & "Less than" as 'True'/'False' or 'n/a' results. Goal is to see
over the course of 1 year, the count of 'True' and 'False' and 'n/a' results
for each employee. I will then need to combine over the course of 2004-2008,
the same count results for each employee. I'll start with info. per year for
now, though.
I hope this makes sense. Need more information, please ask. Thank you very
much!