Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Consolidation Ranges in pivot tables
I have a workbook with two sheets of about 40,000 rows each, when I try to
use the Multiple Consolidation Ranges option I don't see what is expected in the field list ie. a list of the column/row names. Instead I get "row column value". |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Multiple Consolidation Ranges in pivot tables
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 in a database, and create the pivot table from that. Steve S wrote: I have a workbook with two sheets of about 40,000 rows each, when I try to use the Multiple Consolidation Ranges option I don't see what is expected in the field list ie. a list of the column/row names. Instead I get "row column value". -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Minimize the size of a file that contains multiple Pivot Tables | Excel Discussion (Misc queries) | |||
Refreshing multiple pivot tables | Excel Discussion (Misc queries) | |||
two Pivot Tables One pivot chart | Excel Discussion (Misc queries) | |||
Updating Multiple Pivot Ranges | Excel Discussion (Misc queries) | |||
Pivot Table - Multiple consolidation Range | Excel Worksheet Functions |