LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 24
Default Combine Pivot tables - confused about 'how-to'

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combine Pivot Tables April I''m not quite sure... Excel Worksheet Functions 1 April 17th 08 06:32 PM
Building pivot tables in Excel 2007 based on existing pivot tables? [email protected] Excel Discussion (Misc queries) 4 December 26th 07 08:05 PM
combine 2 tables of data into one based on date Tim Nealon Excel Worksheet Functions 5 September 1st 06 01:42 AM
In Excel combine tables from multiple worksheets in to one sheet? Pau Excel Worksheet Functions 1 June 25th 05 12:31 AM
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. stvermont Excel Discussion (Misc queries) 1 February 17th 05 01:34 AM


All times are GMT +1. The time now is 07:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"