Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to combine two data source into one pivot table
I have an actual sales data source, and budget sales data source, i need to
compare actual vs budget years, is there a way to merge two data source into one pivot table? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to combine two data source into one pivot table
Chances are for what you want to do you are going to have to merge the two
data sources together prior to creating the pivot. MS Access is good for doing that kind of thing (if you are fimiliar with Access). Otherwise you will have to create a single data source somewhere in XL (which may require a bunch of manipulation). -- HTH... Jim Thomlinson "Holly" wrote: I have an actual sales data source, and budget sales data source, i need to compare actual vs budget years, is there a way to merge two data source into one pivot table? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to combine two data source into one pivot table
I know very little in access, but I know how to pivot the data from
access data source. How to combine two excel data file into one access file? Two excel files have different rows and columns, but contains most same structures. Thanks, Holly "Jim Thomlinson" wrote: Chances are for what you want to do you are going to have to merge the two data sources together prior to creating the pivot. MS Access is good for doing that kind of thing (if you are fimiliar with Access). Otherwise you will have to create a single data source somewhere in XL (which may require a bunch of manipulation). -- HTH... Jim Thomlinson "Holly" wrote: I have an actual sales data source, and budget sales data source, i need to compare actual vs budget years, is there a way to merge two data source into one pivot table? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table - Combine 2 lists for source data | Charts and Charting in Excel | |||
Pivot Table - Combine 2 lists for source data | Charts and Charting in Excel | |||
Pivot Table data source | Excel Worksheet Functions | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
How do I combine four data items into one in a Pivot Table? | Excel Discussion (Misc queries) |