| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can you have two pivot tables on one worksheet?
Is it possible to have multiple pivot tables on one worksheet? The various
pivot tables will be using the same source data. I just want to show different things with each one. Thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can you have two pivot tables on one worksheet?
Hi,
Just you can copy the PV under the other one and then select the fields you need "trainer07" wrote: Is it possible to have multiple pivot tables on one worksheet? The various pivot tables will be using the same source data. I just want to show different things with each one. Thanks! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can you have two pivot tables on one worksheet?
To uncouple multiple PivotTables,
convert the common source List/Table into a range and give the same range two or more different defined names. (Include header range) Go to the source definition for each PT and enter a different source name for each PT. Turn the source range back into a Excel 2007 Table or Excel 2003 List. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Pivot Tables in same worksheet | Excel Worksheet Functions | |||
| Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
| drill down worksheet placement (pivot tables) | Excel Discussion (Misc queries) | |||
| Two pivot tables on the same worksheet? I need help... | Excel Worksheet Functions | |||
| How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Linear Mode
