Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I have a large CSV data file that I am using as an "external data source" for a Pivot table in an (autoupdate) template. That works fine. It's the sales file created automatically by an application. So it's "sales.csv" and my template with the Pivot table is "sales.xlt". But I also have costs, so I have another file where costs are recorded manually. The data is in "Costs.xls" and I will have another Pivot table where I analyse the costs : "Costs.xlt" Now I want to offset Costs against Sales, so I am looking for some way to get a new pivot table to read both the Sales.CSV and the Costs.XLS data and combine the results. Anyone here know how to do that ? Or, can anyone point me to a site where that is explained. TIA Erasmus |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot Table Data Field Query | Excel Worksheet Functions | |||
Combining Pivot Tables - Summarising data from 100,000 rows | Excel Discussion (Misc queries) | |||
Pivot Table for survey data w/ questions as Rows & poss answrs as | Excel Discussion (Misc queries) | |||
pivot table | Excel Discussion (Misc queries) | |||
Pivot table of data in more than one worksheet | Excel Discussion (Misc queries) |