Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi, I am creating a pivot table from multiple worksheets....which is no
problem in itself......however....my table has in column A the department ID, in column B the employee name, and in column C the data. When I consolidate it only pulls the department ID and the data....but I need the corresponding info (column B) to pull as well.....how do I do this....I have tried everything. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
If you create a Pivot Table from multiple consolidation ranges, as you
discovered, you won't get the same pivot table layout that you'd get from a single range. There's more information he http://www.contextures.com/xlPivot08.html Perhaps you can store the data on one worksheet, and create the pivot table from that. because wrote: Hi, I am creating a pivot table from multiple worksheets....which is no problem in itself......however....my table has in column A the department ID, in column B the employee name, and in column C the data. When I consolidate it only pulls the department ID and the data....but I need the corresponding info (column B) to pull as well.....how do I do this....I have tried everything. -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Filename reference in Spreadsheet XML issue | Excel Discussion (Misc queries) | |||
Display the source for a pivot table page field | Excel Worksheet Functions | |||
Insert a row after a pivot table | Excel Discussion (Misc queries) | |||
Derived Columns in Pivot Table | Excel Discussion (Misc queries) | |||
Pivot -- want to use Max and Sum in same table | Excel Worksheet Functions |