Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine two data sources into one pivot table
I have one worksheet that has budget figures and one that has actuals.
Is there a way for me to combine these into a single pivot table. "budget" and "actuals" should be different fields of course. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine two data sources into one pivot table
This sounds pefectly possible to me but you need to provide more details.
Is the data all in one Workbook or more? "Shig" wrote: I have one worksheet that has budget figures and one that has actuals. Is there a way for me to combine these into a single pivot table. "budget" and "actuals" should be different fields of course. . |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine two data sources into one pivot table
Hi,
summarize in one sheet your information one column called Budget and the other Actuals, then run the pivot table "Shig" wrote: I have one worksheet that has budget figures and one that has actuals. Is there a way for me to combine these into a single pivot table. "budget" and "actuals" should be different fields of course. . |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine two data sources into one pivot table
Depends on the version of Excel - I per chance you are using 2010, yes I said
that, you can use PowerPivot to do it. In 2007 and earlier you can use Microsoft Query and write a union query, but you really need to know what you are doing. The easiest way is to do as previously suggested - combine the data into a singe range and pivot that. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Shig" wrote: I have one worksheet that has budget figures and one that has actuals. Is there a way for me to combine these into a single pivot table. "budget" and "actuals" should be different fields of course. . |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Combine two data sources into one pivot table
I'm using Excel 2007, and the data is in one workbook but two
different worksheets. Other than using a Microsoft Query, it sounds like the only way to do it is to combine the data into a single sheet as suggested. Thanks. On Jan 28, 3:34*pm, Shane Devenshire wrote: Depends on the version of Excel - I per chance you are using 2010, yes I said that, you can use PowerPivot to do it. In 2007 and earlier you can use Microsoft Query and write a union query, but you really need to know what you are doing. The easiest way is to do as previously suggested - combine the data into a singe range and pivot that. * -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Shig" wrote: I have one worksheet that has budget figures and one that has actuals. Is there a way for me to combine these into a single pivot table. "budget" and "actuals" should be different fields of course. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table - multiple data sources | Excel Discussion (Misc queries) | |||
how to combine two data source into one pivot table | Excel Discussion (Misc queries) | |||
Pivot Table - Combine 2 lists for source data | Charts and Charting in Excel | |||
How do I combine four data items into one in a Pivot Table? | Excel Discussion (Misc queries) | |||
Combining two data sources in a Pivot table. | Excel Discussion (Misc queries) |