Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables with Multiple ranges
I am trying to create pivot table with multiple ranges because ther is too
much data for 1 spreadshhet and I don't want to consolidate. I am selecting datas from 3 different tabs and all are in the same formate with 7 columns but have differenet numbers of rows. when I select the ranges and create the pivot table the only options I have to put into the Page header and body are Row, column and Value. This isn't flexible enough I wanted to be able to slect from all the fields in the data ranges. Is there a solution? Have I done something wrong? Thanks Rick |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MSDN article on Excel Limitations in Pivot Tables for Multiple consolidation ranges | Excel Worksheet Functions | |||
build a pivot table from multiple other pivot tables. | Excel Discussion (Misc queries) | |||
Multiple Consolidation Ranges in pivot tables | Excel Worksheet Functions | |||
how do I consolidate multiple pivot tables into one pivot table? | Excel Discussion (Misc queries) | |||
multiple pivot ranges | Excel Worksheet Functions |