Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables
Is it possible to create a pivot table extracting data from 3 separate tabs
in 1 .xls (auto calculated) without created a fourth tab (for totals) and building the pivot table from that? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Tables
The pivot tables have an option for Multiple Consolidation Ranges, but it is
not the same as the usual pivot table, as here you can only play with "row", "column", "value" and "page", that normally is not what you would expect. So the short answer is No, you need to consolidate the data to create a pivot table. Miguel. "Stephanie Lampert" wrote: Is it possible to create a pivot table extracting data from 3 separate tabs in 1 .xls (auto calculated) without created a fourth tab (for totals) and building the pivot table from that? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refreshing Pivot Tables linked to Oracle Datasource | Excel Discussion (Misc queries) | |||
Multiple Pivot tables from One selection | Excel Discussion (Misc queries) | |||
Dynamically changing several pivot tables at once | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |