Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! -- heyredone |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Combine Pivot Tables | Excel Worksheet Functions | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
combine 2 tables of data into one based on date | Excel Worksheet Functions | |||
In Excel combine tables from multiple worksheets in to one sheet? | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |