Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Pivot Table-Using Multiple SS's or Ranges?
I'm familiar with creating and editing Pivot Tables using
one worksheet. I would like to create a Pivot Table using different worksheets. The structure of all the lists are the same: same Header Row in each list. I'm going through the procedure and it is producing a Pivot Table but it is quite different from the Pivot Table Layouts that I'm used to seeing. When I go into the Layout Dialog Box, I'm not seeing the Field Names that one normally sees. 1) Am I doing something wrong? 2) Is this the way it works when you create a Pivot Table from multiple sources? 3) Should I just put all the data in one worksheet list and them produce the Pivot Table? Any assistance would be greatly appreciated as this is frustrating me mucho. Thanks! Jugglertwo |
#2
|
|||
|
|||
You're not doing anything wrong. 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 an example he http://www.contextures.com/xlPivot08.html If possible, store your data in a single worksheet, and you'll have more flexibility in creating the pivot table. Jugglertwo wrote: I'm familiar with creating and editing Pivot Tables using one worksheet. I would like to create a Pivot Table using different worksheets. The structure of all the lists are the same: same Header Row in each list. I'm going through the procedure and it is producing a Pivot Table but it is quite different from the Pivot Table Layouts that I'm used to seeing. When I go into the Layout Dialog Box, I'm not seeing the Field Names that one normally sees. 1) Am I doing something wrong? 2) Is this the way it works when you create a Pivot Table from multiple sources? 3) Should I just put all the data in one worksheet list and them produce the Pivot Table? Any assistance would be greatly appreciated as this is frustrating me mucho. Thanks! Jugglertwo -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Debra:
Thanks so much for the info! It is appreciated ! Jugglertwo -----Original Message----- You're not doing anything wrong. 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 an example he http://www.contextures.com/xlPivot08.html If possible, store your data in a single worksheet, and you'll have more flexibility in creating the pivot table. Jugglertwo wrote: I'm familiar with creating and editing Pivot Tables using one worksheet. I would like to create a Pivot Table using different worksheets. The structure of all the lists are the same: same Header Row in each list. I'm going through the procedure and it is producing a Pivot Table but it is quite different from the Pivot Table Layouts that I'm used to seeing. When I go into the Layout Dialog Box, I'm not seeing the Field Names that one normally sees. 1) Am I doing something wrong? 2) Is this the way it works when you create a Pivot Table from multiple sources? 3) Should I just put all the data in one worksheet list and them produce the Pivot Table? Any assistance would be greatly appreciated as this is frustrating me mucho. Thanks! Jugglertwo -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Removing errors from a Pivot table | Excel Discussion (Misc queries) | |||
Pivot Table combining multiple columns | Excel Discussion (Misc queries) | |||
How do I use multiple worksheets (List) in a Pivot Table Report? | Excel Worksheet Functions | |||
copy pivot table to multiple worksheets | Excel Worksheet Functions | |||
Problem with Pivot Table Drop-Down Menus | Excel Worksheet Functions |